undefined

Savita_Mishra — Thu, 17 Aug 2023 06:17:23 GMT

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

Re: undefined

SamInogic — Mon, 21 Aug 2023 11:03:06 GMT

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 crm@inogic.com

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

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

topic Re: undefined in Developer

undefined

Re: undefined