Forum Discussion
Helper IIIF Condition
Hi,
I have two dates 1. Shipment Date 2. Actual Shipment Date with Order Quantities. Now want to have IF condition where I can get the status if it is shipped Early (with number of days) , On Time or Delay (with number of days).
Thank you so much for help!
Munawar1881 write this calculated column:
Status = VAR _days = ABS(DATEDIFF('Table'[Shipment Date], 'Table'[Actual Shipment Date], DAY)) RETURN SWITCH( TRUE(), 'Table'[Shipment Date] < 'Table'[Actual Shipment Date], "Delay by " & _days & IF(_days = 1, " day", " days"), 'Table'[Shipment Date] > 'Table'[Actual Shipment Date], "Early by " & _days & IF(_days = 1, " day", " days"), "On Time" )
Here is a link to download the file with the solution:
IF Condition 2022-08-02.pbix
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.
SpartaBI Logo
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
Showcase Report – Contoso By SpartaBIMunawar1881 change the code to this:
Status = VAR _days = ABS(DATEDIFF('Table'[Shipment Date], 'Table'[Actual Shipment Date], DAY)) RETURN SWITCH( TRUE(), 'Table'[Actual Shipment Date] = BLANK(), "On Time", 'Table'[Shipment Date] < 'Table'[Actual Shipment Date], "Delay by " & _days & IF(_days = 1, " day", " days"), 'Table'[Shipment Date] > 'Table'[Actual Shipment Date], "Early by " & _days & IF(_days = 1, " day", " days"), "On Time" )
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.
SpartaBI Logo
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
Showcase Report – Contoso By SpartaBIMunawar1881 here is a link to download the file with the solution:
IF Condition 2022-08-02.pbix
8 Replies
- SpartaBI
Community Champion
Munawar1881 write this calculated column:
Status = VAR _days = ABS(DATEDIFF('Table'[Shipment Date], 'Table'[Actual Shipment Date], DAY)) RETURN SWITCH( TRUE(), 'Table'[Shipment Date] < 'Table'[Actual Shipment Date], "Delay by " & _days & IF(_days = 1, " day", " days"), 'Table'[Shipment Date] > 'Table'[Actual Shipment Date], "Early by " & _days & IF(_days = 1, " day", " days"), "On Time" )
Here is a link to download the file with the solution:
IF Condition 2022-08-02.pbix
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.
SpartaBI Logo
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
Showcase Report – Contoso By SpartaBI
Munawar1881It works. Thak you so much for your help
- SpartaBI
my pleasure 🙂
Check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas. Please give it a thumbs up over there if you liked it 🙂
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543