Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |