Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
ManuApo
Helper II
Helper II

Struggling closing/writing IF statement :(

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

 

Capture.PNG

1 ACCEPTED SOLUTION
PhilipTreacy
Super User
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



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

2 REPLIES 2
PhilipTreacy
Super User
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



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


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.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.