Forum Discussion
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 if statement
Column= IF('Table2'[DueDate]<[MeasureDate ],"Active","Paid")
Any help would be greatly appreciated
4 Replies
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")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")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.
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
