Add extra column

[Vinayak1991]

• 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

[lbendlin · Accepted solution]

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.

[v-hashadapu]

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.

[v-hashadapu]

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 you

[ryan_mayu · Accepted solution]

@Vinayak1991 

pls see the attachment below

you need to modify the Q column DAX to meet your real situation

[lbendlin · Accepted solution]

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.