Comments by AndyW1969

AndyW1969 18-Apr-24 10:37am View

thanks again. "Does not work" meant that no data was returned. I have found a workaround - I now store the date in question to a sql table. This value is updated by a stored procedure that runs daily. I've changed the measure so that instead of calculating the date, it picks it up directly from the sql table. New measure:

EndOfWeekDate =

/*CALCULATE(max('Calendar'[Date]),'JOJO Calendar'[IsWeeklyReportWeek]=TRUE())*/

CALCULATE (MAX('Settings'[ValueDate]), 'Settings'[SettingName]="MaxDate")

thanks again.

AndyW1969 18-Apr-24 10:15am View

Yes that works fine. So you would expect the measure to, also. Very strange. Btw thanks for your responses on this.

AndyW1969 18-Apr-24 9:22am View

Yes it evaluates to a date of the format dd/mm/yyyy, with a value of 13/04/2024

AndyW1969 18-Apr-24 7:10am View

thanks for your reply. Here's the measure syntax. I can display this measure in a card visual and it shows the correct date value.

EndOfWeekDate = CALCULATE(max('Calendar'[Date]),'Calendar'[IsWeeklyReportWeek]=TRUE())

Comments by AndyW1969 (Top 4 by date)