Grouping by age

Question

Morning all,I thought I'd get a bit of time in Power BI this lovely Saturday morning. I clearly live the rock and roll lifestyle ;-)&nbsp;I have a list of queries for which I have created a measured column to calculate how old they are in days. What I'd like to do now is create a seperate column which categories them into&nbsp;4 age brackets:&nbsp;0-5 Days6-20 Days21-50 Days&gt;50 Days&nbsp;All help and assistance appreciated.&nbsp;&nbsp;&nbsp;&nbsp;

sean · Answer

&nbsp;AnonymousIt seems you have it right? Are you getting an error or...?Age Range =
CALCULATE (
    VALUES ( 'Age Profile Ranges'[Age Range Name] ),
    FILTER (
        'Age Profile Ranges',
        'Current'[Incident Age (Days)] &gt;= 'Age Profile Ranges'[Min]
            &amp;&amp; 'Current'[Incident Age (Days)] &lt; 'Age Profile Ranges'[Max]
    )
)Alternatively you can create a COLUMN in your 'Current' table and use a SWITCH to create your groups like this...Age Range ALT =
SWITCH (
    TRUE (),
    'Current'[Incident Age (Days)] &gt;= 0
        &amp;&amp; 'Current'[Incident Age (Days)] &lt;= 5, "0-5 Days",
    'Current'[Incident Age (Days)] &gt; 5
        &amp;&amp; 'Current'[Incident Age (Days)] &lt;= 20, "6-20 Days",
    'Current'[Incident Age (Days)] &gt; 20
        &amp;&amp; 'Current'[Incident Age (Days)] &lt;= 50, "21-50 Days",
    "&gt;50 Days"
)That should do it also! :smileyhappy:&nbsp;

phil_seamark · Answer

Hi&nbsp;Anonymous&nbsp;Do you have a relationship between the 'Age&nbsp;Profile Ranges' table and 'Current' ?

anonymous · Answer

If you create a column on your 'Age profile Ranges' table that represents the order you want for each segment, let's say we call it Position and then create a calculated table with two columns, segments and Position, you can define the segments column to sort based on&nbsp;the Position column. This calculated table will be your dimension table that you can relate to your fact table.&nbsp;Table = SUMMARIZE('Age Profile Ranges';'Age Profile Ranges'[Age Range Name];'Age Profile Ranges'[Position])&nbsp;You can make the Postion column invisible to the client tools.&nbsp;&nbsp;

jawed · Answer

Hi. I was going through the discussions and came across this one which I thought will be a lot easier:&nbsp;

owenauger · Answer

Hi&nbsp;Anonymous&nbsp;Static Segmentation is probably the way to go, if you want to assign each row of your table to a group:http://www.daxpatterns.com/static-segmentation/&nbsp;Regards,Owen

Forum Discussion

Grouping by age

10 Replies

Related content

Age Bins

Sorting of age group

Grouping Age by Age Brackets

Creating age groups

stock ageing