Forum Discussion
Change Year Into Quarter
Hi Neetu_2502
I don't know if you took the Dax calendar or PQ, but the logic is the same.
For year quarter you can add a column with :
[Year] & " " & [Quarter]To sort this column you can add a column with the logic :
For descending sort at matrix column:
The pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Thanks for your response!
I have created Datedimension table. Link helped.
I need to show Quarter and year as one slicer tile now, for instance 2023 q1, 2023 q2 etc.
Also, If I use Year field to Matrix from date dimension need the filed to be sorted in Desc order. Do I need to add another column as "sortorder"? if so how to add that.
How to do that
- Ahmedx
Super User
try creating a calendar like this
- Ritaf1983
Hi Neetu_2502
I don't know if you took the Dax calendar or PQ, but the logic is the same.
For year quarter you can add a column with :
[Year] & " " & [Quarter]To sort this column you can add a column with the logic :
For descending sort at matrix column:
The pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
