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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
mn75224
Frequent Visitor

If statement not working correctly

See below picture: 

I do not want -99 to be returned. I would like the value for the 8/1/2023 TRIR column to be returned. in this case (0.91).

mn75224_0-1692211735688.png

 

1 REPLY 1
Syk
Super User
Super User

If statement is working correctly. It's looking to see if the month is = 12, IF IT IS then give TRIR YTD, IF NOT then give -99. I think you just have your ending arguments mixed up

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors