Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dynamic Bucket Column

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 col...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • jdbuchanan71's avatar
    jdbuchanan71
    5 years ago

    Anonymous 

    A new column on that table like this should work.

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

     

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
5 years ago

Anonymous 

A new column on that table like this should work.

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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's avatar
      jdbuchanan71
      Icon for Super User rankSuper User
      5 years ago

      Just add a column like this.

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

      Then set the sort by on Range to Range Sort.