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,
I have a requirement to create bins/ranges for Total Sales as shown in the screenshot below:
I have tried creating DAX Measure for this :
Can you pls help me resolve this requirement as to how to display all the bins/ranges for each vertical?
Please let me know if you need more information or if the requirement is not clear enough.
Here is the sample data with expected output:
https://docs.google.com/spreadsheets/d/1aDJ3-bPulmtj4teKzgtuZ7CcsQ4HuhZs/edit?usp=sharing&ouid=11317...
@Ashish_Mathur- Can you please help me with this?
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi,
In the actual source data, do you have column C already or is that something you created manually? Please share the exact column that are there in your raw data set.
Hi @Ashish_Mathur,
You are right, Column C is not there already in my dataset. Columns H and I are the ones I am trying to create. Updated the sheet.
https://docs.google.com/spreadsheets/d/1aDJ3-bPulmtj4teKzgtuZ7CcsQ4HuhZs/edit?usp=sharing&ouid=11317...
Hi,
You may download my PBI file from here.
Hope this helps.
Hi @Ashish_Mathur,
Thank you for the amount of time and effort you put into this.
That was very helpful.
You are welcome.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |