Group values

[gio1082]

Hi, 
I have the age by days of different material in a column (30, 560,100), I want to group the values by "age < 365" and "age >365" 

how do I do this? thank you in advance!

[nandic · Accepted solution]

@gio1082 , you can make calculated column in dax:

Criteria = IF(Table[DaysPassed]<=365,"Age < 365","Age > 365")

You can do the same in Power Query using conditional column.
Steps: Add column > Conditional Column > create rule

[Fowmy]

@gio1082 

Can you share some sample data? You paste right on the reply box.

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn