IF Condition

[Munawar1881]

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!

[SpartaBI · Accepted solution]

@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

      

Showcase Report – Contoso By SpartaBI

[SpartaBI · Accepted solution]

@Munawar1881 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"
)

      

Showcase Report – Contoso By SpartaBI

[SpartaBI · Accepted solution]

@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

      

Showcase Report – Contoso By SpartaBI

[Munawar1881]

It 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

[Munawar1881]

If the oder is shipped in shipped date and actual shipment date is empty. normally It should be On Time but it shows delay. please guide me how can I solve it 

[Munawar1881]

Hi,

Please help me!

If my purchase order quantity is equal to shipped quantity then 100% (Good)performance if purchase order quantity is less then shipped quantity then -% (Poor) Performance if purchase order quantity is higher than shipped quantity then +% (Best) performance.
within the expected shipment date. if date limit exceeds then delay days + PO Quantity = %Performance    

Thanks for help!

[SpartaBI]

@Munawar1881 hey can you share maybe a sample data so I could copy paste it to PBIX and also just hard code the result you want to get and show why

[SpartaBI · Accepted solution]

@Munawar1881 here is a link to download the file with the solution:
IF Condition 2022-08-02.pbix

[SpartaBI · Accepted solution]

@Munawar1881 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"
)

      

Showcase Report – Contoso By SpartaBI