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
Floriankx's avatar
Floriankx
Solution Sage
8 years ago

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'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.