Forum Discussion

Pricey79's avatar
Pricey79
Helper V
5 years ago
Solved

Datediff? Help please

Hello I was hoping someone could help me please   I have two columns, all in the same query.  Target Date and Actual Date   I'd like to work out when the actual date is the same as the target d...
  • Fowmy's avatar
    5 years ago

    Pricey79 

    You can add a new column to your table using DAX as follows:

    Check Date = if( Table[actual date] =  Table[target date] , "Same", if (  Table[actual date] >  Table[target date] , "Ealier"))