Matrix table - Fiscal Year

[Anonymous]

Hi there,

I have a matrix table and I want to change the display format to fiscal. How can I do it?

Thanks,

This is how my Date Dimension table look like

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please use the following formula to create a Rank column, and then sort Month column by it:

Rank = 
var _first= CALCULATE(MIN('Table'[Month No]),FILTER('Table',[Fiscal  Quarter]="Q1"))
return IF([Month No]>=_first,[Month No],12+[Month No])

Output:

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

[lbendlin]

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with. Please show the expected outcome.

[Anonymous]

This is all I have. The numbers are the total of some numbers.

All I want to do is to arrange the columns so it starts from June instead of January.

[lbendlin]

Please provide data in a usable format. We cannot work with screenshots.