MULTIPLE IFS

[Anonymous]

Hello fellow PBI users,

do you know the formula below in Power bi? i got so used in Tableau finding hard to replicate this in PBI

IF [SHIP_DATE] < TODAY()
THEN 'Backlog'
ELSEIF [SHIP_DATE] < TODAY() + 2
THEN 'Today'
ELSEIF [SHIP_DATE] < TODAY() + 6
THEN 'N5D'
ELSE 'Future'
END

[Fowmy]

@Anonymous 

Try this as new column in your table:

Shipment Status =
SWITCH (
    TRUE (),
    [SHIP_DATE]  < TODAY () + 6, "N5D",
    [SHIP_DATE]  < TODAY () + 2, "Today",
    [SHIP_DATE]  < TODAY (), "Backlog",
    "Future"
)

[sirlanceohlott]

@jppv20 has the solution for you!

[jppv20 · Accepted solution]

Hi @Anonymous ,

The formula should be like this:

Column = IF([SHIP_DATE] < TODAY(),

'Backlog',

IF([SHIP_DATE] < TODAY() + 2,

'Today',

IF([SHIP_DATE] < TODAY() + 6,

'N5D',

'Future'

)))

Jori

If I answered your question, please mark it as a solution to help other members find it more quickly.