Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello community,
I am struggling closing an IF statement, it's almost done but there is something else I need to do.
Basically when the if statement is calculated, I just want to in casa the result is -1, to give me a 0, else give me the result of the IF statement.
I tried to do a nested IF statement: IF( IF ( ...normal statement) = -1, 0 ) but it's not working. Doesn't give me back the results of the inside IF statement when it's not -1.
Any thoughts???
I have attached a screenshot of the IF statement and the result.
Thank you so much,
Manu
Solved! Go to Solution.
Hi @ManuApo
Calculate the value first then check if it equals -1 and return the appropriate value
Use this code - note that I haven't typed out the entire CALCULATE. Please supply code as text raher than an image so it doesn't have to be retyped.
First answer by UW Timeline =
VAR Res = CALCULATE( SUM('Calendar'[Workday]), .......
RETURN
IF (Res = -1, 0, Res)
Regards
Phil
Proud to be a Super User!
Hi @ManuApo
Calculate the value first then check if it equals -1 and return the appropriate value
Use this code - note that I haven't typed out the entire CALCULATE. Please supply code as text raher than an image so it doesn't have to be retyped.
First answer by UW Timeline =
VAR Res = CALCULATE( SUM('Calendar'[Workday]), .......
RETURN
IF (Res = -1, 0, Res)
Regards
Phil
Proud to be a Super User!
Thank you so much @PhilipTreacy !!
I dont know how I couldn't think about that one!
Thanks again 🙂
Manu.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
116 | |
108 | |
107 | |
93 | |
70 |
User | Count |
---|---|
173 | |
135 | |
131 | |
96 | |
94 |