Order Date with functions day()

[Mgx]

I use function day() to print only the number of my days. With set analysis I have 8 data. If my data are on two months I don't have the right sorting.

In dimension : I have : day(Date)

In measure : sum({< Date = {">=12/30/2020<=1/6/2021"}> } Prix)

I want order : 30/31/1/2/3/4/5/6 because 30 december is before 1st January ... 

Thanks

[rwunderlich]

Make your dimension

Dual(day(Date), Date)

and set your sorting to numeric.

-Rob