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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
diagnosed
Frequent Visitor

Setting a calculated column value by another value in the same row

Hi all,

 

Complete newbie to PowerBI but I've done some digging before throwing this out there - my organization uses a feedback rating system where we have something like:

 

1 star = 0 points

2 star = 0 points

3 star = 50 points

4 star = 50 points

5 star = 100 points

 

We have a table of customer responses where we already have a "Rating" column, with a numeric value 1-5. I want to create a calculated column that checks the value of the "Rating" column in the same row, and provides 0, 50, or 100 based on whether it's 1/2, 3/4, or 5 (since I'll then be able to build out averages based on the point metric from there). Apologies if the answer is obvious or the question isn't structured well, I've dug through everything I could find on it and can't quite get anything that even somewhat works. I'm happy to puzzle out the precise syntax if I can at least be pointed at what functions I should be considering.

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

Column = IF([Rating]<3,0,IF([Rating]<5,50,100))


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Greg_Deckler
Super User
Super User

Column = IF([Rating]<3,0,IF([Rating]<5,50,100))


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Thank you Greg, much appreciated! Helps me build out a few other calculated columns I'm working on too.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.