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
Rahulsingh's avatar
Rahulsingh
Helper I
8 years ago

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's avatar
Rahulsingh
Helper I
8 years ago

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.