Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Quarter organization

I have a matrix in which I'm using quarters to define my columns. My matrix currently looks like this   Full Year           Q1            Q2             Q3            Q4   I want it to look like ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

     

    Thanks for the reply from aduguid , please allow me to provide another insight: 

     

    1. Create a calculation table and assign values ​​to the quarters in order.

    Table 2 =
ADDCOLUMNS(DISTINCT('Table'[Quarter]),"num",SWITCH('Table'[Quarter],
"Q1",1,
"Q2",2,
"Q3",3,
"Q4",4,
"full year",5))

     

    2. Sort the Quarter column by the num column.

     

    3. Create a relationship between the two tables.

     

    4. Put the dax of the calculation table in the column of the matrix.

     

    If your Current Period does not refer to this, please clarify in a follow-up reply.

     

    Best Regards,

    Clara Gong

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

 

Thanks for the reply from aduguid , please allow me to provide another insight: 

 

1. Create a calculation table and assign values ​​to the quarters in order.

Table 2 =
ADDCOLUMNS(DISTINCT('Table'[Quarter]),"num",SWITCH('Table'[Quarter],
"Q1",1,
"Q2",2,
"Q3",3,
"Q4",4,
"full year",5))

 

2. Sort the Quarter column by the num column.

 

3. Create a relationship between the two tables.

 

4. Put the dax of the calculation table in the column of the matrix.

 

If your Current Period does not refer to this, please clarify in a follow-up reply.

 

Best Regards,

Clara Gong

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