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.
Hello,
I have a table, where each row represents an individual record. It has column called "Number" which is unique name for each record, and a column called "AGE" which shows how old a record is (in days)
I have 7 set ranges (represented by columns):
0-5 days
6-10 days
11-20 days
21-30 days
>30 days
>100 days
>365 days
What I need is to calculate how many records fall under each range.
In Excel, I used to achive this by doing the following calculations:
I would then do a SUM for each range column that would give me total number of records in that Age Range.
Is there an easy way to achieve this in Power BI?
Hi @Anonymous ,
You could reference the blogs to have a try.
Grouping & Segmenting Your Data With DAX Measure Logic - Advanced DAX
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Right, in Power BI you would use a SUMX or COUNTX coupled with a FILTER. You could also use CALCULATE along with SUM.
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |