Check to see if a number in a column is within specified range

[Anonymous]

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?

[v-xuding-msft]

Hi @Anonymous ,

You could reference the blogs to have a try.

Dynamic Segmentation

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.

[Greg_Deckler]

Right, in Power BI you would use a SUMX or COUNTX coupled with a FILTER. You could also use CALCULATE along with SUM.