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.
Hi all,
I'm getting a bit confused with this IF formula:
if [Completion Date] < [#"Month/Year"] and [Status] = Requested and [Status] = In Progress and [Status] = Approved by Management then "Overdue" else ""
The system highlight the word Progress with "Token then expected"
Does that mean that the If Formula can handle only one "and" expression?
Thank you
Christian
Solved! Go to Solution.
Hi @Werfuks
if can handle whatever you throw at it.
What are Requested and In Progress ? Variables? If it's just text, which is what it looks like, you'd have to use
"Requested" and "In Progress". Same for Approved
if [Completion Date] < [#"Month/Year"] and [Status] = "Requested" and [Status] = "In Progress" and [Status] = "Approved" by Management then "Overdue" else ""
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |
You have to enclose the text values in double quotes, like [Satus] = "Requested" and ...
Bur are you sure that "and" is appropriate? How is [Status] going to = "Requested" AND "In Progress" AND "Approved by Management"? The if statement evaluates to true or false per row, so the [Status] will be just one thing, not one thing AND another thing.
--Nate
Many thanks to you guys. With the double quotes it works now!
You have to enclose the text values in double quotes, like [Satus] = "Requested" and ...
Bur are you sure that "and" is appropriate? How is [Status] going to = "Requested" AND "In Progress" AND "Approved by Management"? The if statement evaluates to true or false per row, so the [Status] will be just one thing, not one thing AND another thing.
--Nate
Hi @Werfuks
if can handle whatever you throw at it.
What are Requested and In Progress ? Variables? If it's just text, which is what it looks like, you'd have to use
"Requested" and "In Progress". Same for Approved
if [Completion Date] < [#"Month/Year"] and [Status] = "Requested" and [Status] = "In Progress" and [Status] = "Approved" by Management then "Overdue" else ""
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |
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 |
---|---|
101 | |
52 | |
21 | |
12 | |
11 |