Is there a way of being able to categorise my data into certain months for example, I have data that I want to be able to categorise into 0-12 months and 25-48 months and anything else would be "Other", what would be the quickest way of doing this?
Go to Solution.
@UK_User123456 Please add a new column as below
VAR _MonthsDiff = DATEDIFF([Date],TODAY(),MONTH)
RETURN IF(_MonthsDiff<=24,"0 -24",IF(_MonthsDiff<=48,"25 - 48","Other"))
Added MonthsDiff column, just for reference.
Proud to be a Datanaut !
View solution in original post
Hi @UK_User123456 ,
You can also use M query to do it. Here is my test file, you could download and refer to it.
I cannot see how you have created the workings as it wont let me update power bi? Are you able to post the working?
You could open query editor and find "APPLIED STEPS" in the right part. It shows each step to get the final result.
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!