Forum Discussion
Add Quarters to Matrix Table
I am currently using a Matrix Visual with Individual Queries for my Values. Then for my columns I have a date format. Is there any way to total the individual Quarters. For example have new colum...
Hi aishak12 ,
If you have a Date column in your table, you may add it to the columns in the matrix and select quarter in Date Hierarchy.
If you don't have a date column, you may create a separate table as follows.
Quarter
| Qtr 1 |
| Qtr 2 |
| Qtr 3 |
| Qtr 4 |
Then create a measure which will be put into Values in the matrix with SWITCH or IF to make the value of each quarter correspond to your Qtr1, Qtr2, Qtr3 and Qtr4.
Just like:
Measure = SWITCH(MAX('Table (2)'[Quarter]),"Qtr 1",CALCULATE(SUM('Table'[Values]),FILTER('Table',[Month]="January"&&[Month]="February".....
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.