Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi there,
May I know how to write below multiple IFs statement in my PowerBI query :-
IF Actual Cost > 90% of the budget , then "Issue"
IF Actual Cost < 90% and >75% of the budget , then "At Risk"
IF Actuals Cost < 75% of the budget, then "On Forecast"
IF Budget = 0 and Actuals > 15K (20,000 x 75%), then "At Risk"
Basically, I would like to have the output of the "Remark" column
Thank you
Solved! Go to Solution.
@hushpuppies
Create your remarks column using DAX as follows. You may add >= where necessary based on your scenario.
Remark =
SWITCH(
TRUE(),
'Table07'[Budget] = 0 && 'Table07'[Actual] > 15000, "At Risk",
'Table07'[Actual] >= 'Table07'[Budget] * 0.9, "Issue",
'Table07'[Actual] < 'Table07'[Budget] * 0.9 && 'Table07'[Actual] > 'Table07'[Budget] * 0.75, "At Risk",
'Table07'[Actual] < 'Table07'[Budget] * 0.75, "On Forecast",
BLANK()
)
Result:
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@hushpuppies
Create your remarks column using DAX as follows. You may add >= where necessary based on your scenario.
Remark =
SWITCH(
TRUE(),
'Table07'[Budget] = 0 && 'Table07'[Actual] > 15000, "At Risk",
'Table07'[Actual] >= 'Table07'[Budget] * 0.9, "Issue",
'Table07'[Actual] < 'Table07'[Budget] * 0.9 && 'Table07'[Actual] > 'Table07'[Budget] * 0.75, "At Risk",
'Table07'[Actual] < 'Table07'[Budget] * 0.75, "On Forecast",
BLANK()
)
Result:
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@hushpuppies
Gald it worked!
Please accept it as a solution.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi @hushpuppies
with "else" between the statements
Take a look at the linked tutorials:
https://www.youtube.com/watch?v=w57a_XheWz4
https://www.youtube.com/watch?v=o9qAov3kSN4
According to your example if i understood you correctly it will be like this (you can modify the logic if you need).
1. In the first step I added a column of actual % :
2 And then the custom column :
result:
pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly