Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I have a table containing complaints recieved. These have a date attached to them which has been broken down in the table in a heirarchical structure.
I am trying to bucket these dates into the following buckets :
0 - 4 weeks
4 - 8 weeks
8 + Weeks
I have taken the month number and Ranked them using the following formula :
Please can you advise where I have gone wrong and how to correct this?
Regards,
Indy
Solved! Go to Solution.
Hi @indyb
Please check If this result is expected.
Create a new table
date =
ADDCOLUMNS (
CALENDARAUTO (),
"year", YEAR ( [Date] ),
"month", MONTH ( [Date] ),
"monthno", FORMAT (
[Date],
"yyyymm"
),
"monthname", FORMAT (
[Date],
"Mmm yyyy"
)
)
Add calculated columns
rank = RANKX(FILTER('date','date'[Date]<=TODAY()),[monthno],,DESC,Dense)-1
rank bucket = SWITCH([rank],1,"0~4 weeks",2,"4~8 weeks","8+weeks")
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @indyb
Please check If this result is expected.
Create a new table
date =
ADDCOLUMNS (
CALENDARAUTO (),
"year", YEAR ( [Date] ),
"month", MONTH ( [Date] ),
"monthno", FORMAT (
[Date],
"yyyymm"
),
"monthname", FORMAT (
[Date],
"Mmm yyyy"
)
)
Add calculated columns
rank = RANKX(FILTER('date','date'[Date]<=TODAY()),[monthno],,DESC,Dense)-1
rank bucket = SWITCH([rank],1,"0~4 weeks",2,"4~8 weeks","8+weeks")
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.