Forum Discussion
Solved
Add extra column
I have monthwise data of some expenses. I have plotted this data in power bi table(matrix visual)as shown below where I have taken month in columns and expenses in rows resulting monthwise data. But...
Add a calendar table to your data model. Include quarter column there. Then join the calendar table to your fact table via the date. In your matrix put the quarter and yearmonth columns into the column area.
pls see the attachment below
you need to modify the Q column DAX to meet your real situation
Add a calendar table to your data model. Include quarter column there. Then join the calendar table to your fact table via the date. In your matrix put the quarter and yearmonth columns into the column area.