Forum Discussion

Munawar1881's avatar
Munawar1881
Icon for Helper II rankHelper 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 Tim...
if condition
Order in hand
SpartaBI's avatar
SpartaBI
Icon for Community Champion rankCommunity Champion
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


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

  • Munawar1881's avatar
    Munawar1881
    Icon for Helper II rankHelper II
    4 years ago

    It works. Thak you so much for your help

      • Munawar1881's avatar
        Munawar1881
        Icon for Helper II rankHelper II
        4 years ago

        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