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.
Read the announcement for more information!
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Get an overview of the events and great community content from November.
Find out where you can attend!