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,
Im very new to this, this is my first post.
I am having some issues with an IF statement where I am trying to find the MAX value from 5 different columns, where the column is the MAX I want it to return different text. Most of the outputs from my new column are correct but some of them are not and I cannot figure out why as it works on most?
Here is my formula.
Any help would be much appreciated.
I cant see how to attach an excel file so I have added a sample in th etable below. Columns B-F are provided a score. Column G (Top Score) is a MAX calculation of Range B-F. Then Priority is an IF statement using MAX. It is very easy to do this in excel but I am trying to recreate this in power BI and I do not obtain the same results.
There is another slight issue in that on occassion the MAX number is matched between columns, then I need to figure out what to do in that scenario.
Title | £ Score | Trans Score | Closer Score | Proud score | growth score | Top score | Priority |
1 | 15 | 0 | 8 | 0 | 0 | 15 | Top Score |
2 | 15 | 20 | 0 | 0 | 0 | 20 | Trans Score |
3 | 0 | 0 | 5 | 20 | 0 | 20 | Proud Score |
4 | 20 | 15 | 0 | 0 | 0 | 20 | £ Score |
5 | 0 | 0 | 0 | 0 | 0 | 0 | Not Assigned |
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |