undefined

[Savita_Mishra]

• Row level last 4 quarters and last 4 months side by side in power bi Matrix on dynamic 
• Like
• 2021
• Q1
• Q2
• Q3
• Q4
• 2022
• Q1
• Q2
• Q3
• Q4
• 2023
• Q1
• Q2
• Q3
• April
• May
• June 

[SamInogic]

Hi @Savita_Mishra ,

I am bit unclear with exact output, if the expected output is below then you can follow provided steps:

Create a Table with below DAX expression:

CalendarData = CALENDAR(DATE(2021,1,1),DATE(2025,1,1))

Create a column “Quarter” with below DAX expression,

Quarter =

var result = SWITCH(CalendarData[Date].[QuarterNo],1,"Qtr 4",2,"Qtr 1",3,"Qtr 2",4,"Qtr 3")

return result

Create a Column “Month of Fiscal” with below DAX expression,

Month of Fiscal =

var NMonth = CalendarData[Date].[MonthNo]

var monthNo = IF(NMonth>=4 && NMonth <=12, NMonth-3,NMonth+9)

return SWITCH(monthNo,1,"April",2,"May",3,"June",4,"July",5,"August",6,"September",7,"October",8,"November",9,"December",10,"January",11,"February",12,"March")

Now use Matrix to display these columns as shown in below screenshot,

Let me know if your requirement is different from this.

Thanks!

Inogic Professional Services Division

Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!

Drop an email at [email protected]

Services:  http://www.inogic.com/services/

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/