cancel
Showing results for
Did you mean:
Helper I

## Excel formula if else to power bi

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

1 ACCEPTED SOLUTION
Super User

Hey @refint650 ,

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

Check the following article on how that works:

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

2 REPLIES 2
Helper I

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

Super User

Hey @refint650 ,

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

Check the following article on how that works:

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

Announcements