Forum Discussion

Rahulsingh's avatar
Rahulsingh
Helper I
8 years ago

Date Measure and Calculated Column

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 i...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

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