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

[Anonymous]

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.

[Greg_Deckler · Accepted solution]

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

[Anonymous]

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