calculated column ,header position

[SLR_PBI]

I have write one dax as below

RiskBucket = var deptAge= if(('Sage Account Receivables'[Outstanding] > 0), DATEDIFF(RELATED('Date'[Date]),TODAY(),DAY),BLANK()) return
SWITCH(TRUE(),(deptAge >0 && deptAge <= 30),"Low",(deptAge >30 && deptAge <= 60),"Medium",(deptAge > 60),"High")

the output of obove dax is

-------------------------------------------

High      |          Low    |         Medium

-------------------------------------------

5              |         1           |     3  

15            |        11          |     13

25            |        21          |     23

But my requirement is to show in below format

-------------------------------------------

Low        |          Medium |         High

-------------------------------------------

1             |         3           |     5  

11           |        13          |     15

21           |        23          |     25

Column should be in ascending order. 

[v-yuta-msft]

@SLR_PBI ,

I could not find 'RiskBucket ' in the table you given. Could you please give the complete sample data? 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.