Forum Discussion
Automatic grouping data by range
I have manually grouped the data as seen in the below screenshots. Is there a way to automatically group this data so I do not have to go back and edit every time new data is added into my datas...
Hi,
Create a table like this and name it Buckets
Lower Upper Bracket 0 30,000 0 - 30K 30,000 2,50,000 30 - 250K 2,50,000 6,80,000 250 - 680K 6,80,000 10,00,000 680K - 1M 10,00,000 10,00,00,000 > 1M Write this calculated column formula
Column = CALCULATE(MAX(Buckets[Bracket]),FILTER(Buckets,Buckets[Lower]<='Table'[original contract value]&&Buckets[Upper]>='Table'[original contract value]))Hope this helps.
Hi,
Mine is a calculated column formula to be written in the Data Model (not an M language code to be written in the Query Editor).
Thank you very much.
This worked so well. I have applied it to my main report.
Just to confirm - this formula is only using the original contract value column and not the (groups) column?
Christiana
You are welcome. That is correct.
Thank you very much!