Date completed - Date needed = Yes/No

[Anonymous]

Hello I am looking to make a measure for a new column 'In Compliance' that tells if an action Item was completed on or before the date needed, so somthing like;

Date completed - Date needed = Yes/No 

For example

[amitchandak]

@Anonymous ,

new column = if([Date completed] = [Date needed],"Yes","No")

[camargos88 · Accepted solution]

Hi @Anonymous ,

Use this code for a new calculated column:

In Compliance = IF('Table'[Date Completed] <= 'Table'[Date Needed], "Yes", "No")