Showing selected qtr and previous qtr in the matrix

[Kopek]

Hello,

I have a matrix which shows some qtr values based on a slicer selection
(when q1 2022 is slected it shows appropriate data for Q1 2022, when Q2 2023 is selected, then shows values for Q2 2023 and so on).

What i want to achieve is to in addition to selected qtr have a column with previous qtr values.

The trick is, i cannot change a slicer type - it needs to be a single selection dropdown, as it is synced with other pages where it is driven from.
So i could not scratch my head round what calculation to prepare (possible a calculated table?) so that i am having a selcted qtr values + previous qtr values in the matrix visible.

Any ideas ?

Thanks in advance 🙂

[Kopek]

hi @mickey64 , i know how to create a measure to count previous qtr values, but how to embedded that in one matrix as a column ?

So what i want to achievie is a below matrix:
What i am currently able to have is a first two columns and dropdown slicer which is a single qtr selection driven on previous pages

	Q1 2022 (qtr determined by slicer selection)	Q4 2021 ( that column and underneath values to be calcuated based on a slicer selection qtr-1)
1	value	value
1.1	value	value
1.1.1	value	value
1.1.2	value	value
1.1.3	value	value

[mickey64 · Accepted solution]

Step 0: I make and use this DATA Table.

Step 1: I make a calendar table and add a relationship.

Step 2: I make a measure 'Total_PreQ'.

    Total_PreQ = CALCULATE(SUM(DATA[Value]),PREVIOUSQUARTER('Calendar'[Date]))

Step 3: I make a slicer and a matrix.

[Kopek]

Hi @mickey64 , you are right! i was looking at the column/ table level solution... but i can achieve that the other way round and dummy the column headers at the end.

Thanks for unfreezing my brain ! 🙂

[mickey64]

For your reference.

I make a measure.

    Previous Q = CALCULATE(SUM([Value]), PREVIOUSQUARTER('Calendar'[Date]))