Forum Discussion

janwillem's avatar
janwillem
Frequent Visitor
9 years ago
Solved

Column order

I have made a calculate column: Inactive Group =  Calculate( IF('.....'[Days in-active] < 30; "< 30 days"; IF( '.....'[Days in-active] < 90; "30 < 90 days"; IF('.....'[Days in-acitve] < 365; "90 < 3...
Need Help
  • TomMartens's avatar
    TomMartens
    9 years ago

    Hey,

     

    you can't change the order by changing your formula. The default order is derived from the values of signs representing the character code.

     

    For this reason I would recommend to create a new table in the modeling section using this DAX statement

    Inactive Group = 
UNION(
	ROW("Inactive Group", "< 30 days", "Sort Order", 1)
	,ROW("Inactive Group", "30 < 90 days", "Sort Order", 2)
	,ROW("Inactive Group", "90 < 365 days", "Sort Order", 3)
	,ROW("Inactive Group", "> 365 days", "Sort Order", 4)
)

     Next change the default order, goto the model pane mark the column of  "Inactive Group" and choose colum to sort by

     

    In the relationship pane connect the columns with the new table on the one side and your calculated column on the many side. Hide your calculated column from report view and just use the column from the new table.

     

    Hope this helps

TomMartens's avatar
TomMartens
Super User
9 years ago

Hey,

 

you can't change the order by changing your formula. The default order is derived from the values of signs representing the character code.

 

For this reason I would recommend to create a new table in the modeling section using this DAX statement

Inactive Group = 
UNION(
	ROW("Inactive Group", "< 30 days", "Sort Order", 1)
	,ROW("Inactive Group", "30 < 90 days", "Sort Order", 2)
	,ROW("Inactive Group", "90 < 365 days", "Sort Order", 3)
	,ROW("Inactive Group", "> 365 days", "Sort Order", 4)
)

 Next change the default order, goto the model pane mark the column of  "Inactive Group" and choose colum to sort by

 

In the relationship pane connect the columns with the new table on the one side and your calculated column on the many side. Hide your calculated column from report view and just use the column from the new table.

 

Hope this helps

gtamir's avatar
gtamir
Post Patron
8 years ago

 Hi Tom

In this case the headers are numeric and special charachters, what if I want to move one column left or right?