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
Hi Vinayak1991 , Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.