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 sales data upto one laks, I want to group the data like "<1000, 1000-5000", "5000-7000" and <7000.
How to do it in dax function?
somebody help me on this ?
thanks
Solved! Go to Solution.
Hi @AmalrajRRD1,
Add calculated column with below DAX formual.
Group = IF ( Table1[Sales] < 1000, "<=1000", IF ( Table1[Sales] > 1000 && Table1[Sales] <= 5000, "1000-5000", IF ( Table1[Sales] > 5000 && Table1[Sales] <= 7000, "5000-7000", ">7000" ) ) )
Alternatively, you can right click the [sales] field and choose "new group".
Result.
Best regards,
Yuliana Gu
Hi @AmalrajRRD1,
Add calculated column with below DAX formual.
Group = IF ( Table1[Sales] < 1000, "<=1000", IF ( Table1[Sales] > 1000 && Table1[Sales] <= 5000, "1000-5000", IF ( Table1[Sales] > 5000 && Table1[Sales] <= 7000, "5000-7000", ">7000" ) ) )
Alternatively, you can right click the [sales] field and choose "new group".
Result.
Best regards,
Yuliana Gu
Thanks for your Reply.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Need sample data but generally this involves a caculated column or a disconnected table trick measure.
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 |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |