Forum Discussion
Grouping based on number ranges
Hi everyone,
I'm very new to powerbi and trying to muddle my way though it, if any one can help me with this it would be
appreciated.
I have a table with the following columns,
File-Path (this contains a string )
Accessed (This contains time and date)
Age (this is calculated from days, and is the number days from the current day that the file has been accessed)
What I would like to do is to be able to report the number of files that were Accessed within the following ranges
0-30 days
31-90 days
90-180 days
I can see how to create a grouping, but is very fixed and you can't adjust the boundries
Could someone guide me on how to do it ?
Thanks
Matt
2 Replies
- amitchandak
Super User
MattDavies , Grouping or calculated column are options you can have, I doubt you can have dynamic boundaries
new column
Switch(True(),
[Age] <=30 , " 0-30 days",
[Age] <=90 , "31-90 days",
[Age] <=180, "90-180 days")
- V-lianl-msft
Community Support
Hi MattDavies ,
You can refer to this blog:
https://community.powerbi.com/t5/Community-Blog/Group-Bin-in-Power-Query/ba-p/1997205
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.