Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |