DAX IF Month and Year Different Than Target

[Anonymous]

Dear Team

Im back with another question. Shown below :

Thanks any respond

Syaiful

[Anonymous]

@Anonymous Create a custom column that extracts year and adds month and compare.         if (Date.Month([Delivery]) + Date.Year([Delivery])) > (Date.Month([RcvOrder]) + Date.Year([RcvOrder])) then "OUTSTANDING" else "ONTIME")

[amitchandak · Accepted solution]

@Anonymous 

Try like. new column

if(startOFMONTH([deilvery])>startOFMONTH([RecOrder]),"Outstanding","Ontime")

Or

if(format([deilvery],"YYYYMM")>format(startOFMONTH([RecOrder]),"YYYYMM"),"Outstanding","Ontime")

Appreciate your Kudos.

[Anonymous]

Thanks, Appreciated that

Solved