Dynamic Bucket Column

[Anonymous]

Hey hi Guy's,

I have created 1 column like 1-1000 numbers, by using generate dax like this

Now I was trying to creating dynamic bucket column based on first column numbers.

2 nd column like first 10 rows are 1-10,

                            next 10 rows are 10-20

can any one please help me on dynamic bucket column. 

regards,

Tom

[jdbuchanan71 · Accepted solution]

@Anonymous 

A new column on that table like this should work.

Range = CEILING('Table'[Value],10)-9 & "-" & CEILING('Table'[Value],10)

[Anonymous]

hi @jdbuchanan71 ,

Thanks for your dax working fine.

now i want to sort it down order wise.

like 1-10 then 1 and 11-20 then 2

[jdbuchanan71]

Just add a column like this.

Range Sort = CEILING('Table'[Value],10)

Then set the sort by on Range to Range Sort.