Date Measure and Calculated Column

[Rahulsingh]

Hi Everyone 

I have created a measure 

MeasureDate =  CALCULATE(MAX('Table1'[DateRec]),ALLSELECTED('Table1'))

When I try to use this measure in a Calculated column it does not work for the if statement

Column= IF('Table2'[DueDate]<[MeasureDate ],"Active","Paid")

Any help would be greatly appreciated

[v-yulgu-msft]

Hi @Rahulsingh,

If Table1 is not related to Table2, measure [MeasureDate] will work like a static date value in IF statement.

Please try this:

MeasureDate =  CALCULATE(MAX('Table1'[DateRec]),ALL('Table1'))

Column= IF('Table2'[DueDate]<[MeasureDate ],"Active","Paid")

Regards,

Yuliana Gu

[Floriankx]

Hello,

are the tables related?

If so, DAX applies measure to every row.

You could also try to dim your Measure inside your Column:

Column= 
VAR MeasureDate =  CALCULATE(MAX('Table1'[DateRec]),ALLSELECTED('Table1'))
RETURN IF('Table2'[DueDate]<[MeasureDate ],"Active","Paid")

[Rahulsingh]

Hi 

Column= 
VAR MeasureDate =  CALCULATE(MAX('Table1'[DateRec]),ALLSELECTED('Table1'))
RETURN IF('Table2'[DueDate]<[MeasureDate ],"Active","Paid")

Does not work me because it calculates measure date on each row but I want the measured date to be static  like 

eg 

IF('Table2'[DueDate]<"3/21/2018","Active","Paid")

[Rahulsingh]

hi Everyone, 

I have found the solution for this query as we cannot use a measure in our calculated columns, I had to think differently.