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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
viwinski7
Frequent Visitor

Nested If/And Statement for Reassessment Data

Hello BI Community, 

 

I am trying to create a code for this statement: 

 

If at reassessment, the B_Total Score is equal to or less than the B_Total score at inital, then TRUE, all else is FALSE

 

viwinski7_0-1654730519181.pngviwinski7_1-1654730543478.png

 

I'm having a hard time getting it so that it's comparing the Reassessment Score to the Initial Score. There's like an extra layer I haven't mastered as far as how to code it. 

1 REPLY 1
Vijay_A_Verma
Super User
Super User

Initial Score is not clear. If you can also populate the result in a column, that would provide clarity.

You can probably put the data in an Excel and create the result in a column. Post the screenshot of that Excel. 

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