Measure - If less than condition between dates

[gauravnarchal]

Hello

I need your help to create a measure as below

Condition - If Return Date is less than Ship Date return "error" else "ok"

Ship Date	Return Date
27-Feb-21	26-Feb-21

[v-yetao1-msft · Accepted solution]

Hi @gauravnarchal 

Create a measure like this :

Measure = IF(SELECTEDVALUE('Table'[Return Date])<SELECTEDVALUE('Table'[Ship Date]),"error","ok")

The effect is as shown :

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mwegener]

Hi @gauravnarchal ,

Calculated Column

Status = IF(DATEDIFF('Table'[Return Date],'Table'[Ship Date],DAY) > 0,"error","ok")

Measure:

M Status = IF(DATEDIFF(MAX('Table'[Return Date]),MAX('Table'[Ship Date]),DAY) > 0,"error","ok")