Excel formula if else to power bi

[refint650]

Hello ALL

I'm decoding excel forumula IF Else Datelogic calculation couldnt figure how to re-write in Dax or Mquery Calculation need some help .
F = StartDate
G = RelesaseDate
H = PostedDate
I = AccountDate

ActualDate

IF( ActualDate>=StartDate && RelesaseDate>ActualDate) then "A1"
If( ActualDate>=ReleaseDate && Posteddate>ActualDate) then "A2"
If (ActualDate>=PostedDate && Accountdate>ActualDate) then "A2"
if (Startdate>ActualDate) then ""

Thanks

Vs

[refint650]

@selimovd 

Let me  rewrite as you said will let you know . Thank you 🙂

[selimovd · Accepted solution]

Hey @refint650 ,

you can do something like this with the combination of SWITCH with TRUE().

Check the following article on how that works:

https://p3adaptive.com/2015/03/the-diabolical-genius-of-switch-true/

And here the example how it would look like:

ActualDate =
SWITCH (
    TRUE (),
    ActualDate >= StartDate && RelesaseDate > ActualDate, "A1",
    ActualDate >= ReleaseDate && Posteddate > ActualDate, "A2",
    ActualDate >= PostedDate && Accountdate > ActualDate, "A2",
    ""
)

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic