Forum Discussion
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 I also need data for quater to be included in column I hope it is possibleData in excelPower bi reportIntended reoprt. I have attached sample data image for reference
- Data
- Power bi Report
- Intended Report
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
4 Replies
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 , Thank you for reaching out to the Microsoft Community Forum.
Please let us know if your issue is solved. If it is, consider marking the answers that helped 'Accept as Solution', so others with similar queries can find them easily. If not, please share the details.
Thank youHi 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.