Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi I have the following DAX code for a column:
Solved! Go to Solution.
Found my own solution.
Pseudocode:
IF 50th THEN 1. If 75th THEN 2. IF 90th THEN 3. Make these columns for all three percentile columns.
Make a column summing all values from the three columns.
Apply range of Low-High on numbers 3-9, with 3 being Low and 9 being High.
Found my own solution.
Pseudocode:
IF 50th THEN 1. If 75th THEN 2. IF 90th THEN 3. Make these columns for all three percentile columns.
Make a column summing all values from the three columns.
Apply range of Low-High on numbers 3-9, with 3 being Low and 9 being High.
Hi,
I think this is possible. Share the download link of the PBI file and clearly show the table where you want to get the result. Also, share a 4 column table. In the first 3 columns show all possible combinations of 90, 75 and 50. In the fourth column, show the category (text) which describes that combination i.e. High, Medium high etc.
Read about SWITCH()
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
User | Count |
---|---|
94 | |
86 | |
78 | |
70 | |
63 |
User | Count |
---|---|
114 | |
101 | |
97 | |
66 | |
59 |