Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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
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
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |