Hi,
I'm trying to make a dax formula to calculate the date difference between the date on the column and the max(date) column in another table.
DIM_Kalender: Base table which is filtered by using a slicer
Dim_Kalender (2): I want a dynamic datediff() calculation between the row date value and the selected slicer value that filters table DIM_Kalender.
By using the formula below he however doesn't compare the max() value from the other table, but the max value in the current table. By adding the var value in a seperate calculated measure the correct max() value appears.
What is wrong in my DAX calculation?
FlagLast7Days_2 =
var LastFoundDateDataSet_2 = CALCULATE( MAX ( DIM_Kalender[Datum] ); ALLSELECTED ( DIM_Kalender ) )
var Datum = 'DIM_Kalender (2)'[Datum]
return
DATEDIFF( LastFoundDateDataSet_2 ; Datum ; DAY )
Screenshot on the following links:
https://imgur.com/IxybaYE
https://imgur.com/OhnIpwj
Best regards,
M
