Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear Team
Im back with another question. Shown below :
Thanks any respond
Syaiful
Solved! Go to 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 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")
@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.
Thanks, Appreciated that
Solved
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |