Month and quarter Value

[rajasekar_o]

hi team,
I want to display the values as shown in the table below.
How to Achive this .

	Jan	Feb	Mar	Q1	Apr	May	jun	Q2	Jul	Aug	Sep	Q3	Oct	Nov	Dec	Q4	Total
2020	10	10	10	30	10	10	10	30	20	30	40	90	10	20	30	60	210
2021	20	10	30	60	23	12	10	45	10	10	10	30	20	20	80	100	204

[danextian · Accepted solution]

Hi @rajasekar_o ,

You will need a disconnected table containing the periods (month, quarter) and some advanced DAX to achieve that. Please see attached pbix for reference.