Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
98 | |
90 | |
83 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |