cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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

1 ACCEPTED SOLUTION
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!

2 REPLIES 2
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!

Helper II

Thank you so much @PhilipTreacy !!

I dont know how I couldn't think about that one!

Thanks again 🙂
Manu.

Announcements

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors