Datediff? Help please

[Pricey79]

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

[Pricey79]

@Fowmy Thank you very much sir

[Fowmy · Accepted solution]

@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"))