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 date, and when it is earlier. 

How would I work that out please?

 

Thank you in advance

Need Help
  • Fowmy's avatar
    Fowmy
    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"))

2 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    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"))