Forum Discussion

Munawar1881's avatar
Munawar1881
Helper II
4 years ago
Solved

IF 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!

if condition
Order in hand
  • SpartaBI's avatar
    SpartaBI
    4 years ago

    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's avatar
    SpartaBI
    4 years ago

    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

8 Replies