Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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.
Solved! Go to Solution.
Column = IF([Rating]<3,0,IF([Rating]<5,50,100))
Column = IF([Rating]<3,0,IF([Rating]<5,50,100))
Thank you Greg, much appreciated! Helps me build out a few other calculated columns I'm working on too.
User | Count |
---|---|
119 | |
78 | |
59 | |
52 | |
48 |
User | Count |
---|---|
171 | |
117 | |
61 | |
59 | |
53 |