topic % change between previous and current quarters in power bi in DAX Commands and Tips

% change between previous and current quarters in power bi

Anonymous — Thu, 21 Jul 2022 12:13:47 GMT

can you please assist on how do i calculate the % change between previous and current quarters in power bi

Re: % change between previous and current quarters in power bi

SpartaBI — Thu, 21 Jul 2022 13:04:36 GMT

Anonymous read this full article:
https://www.daxpatterns.com/standard-time-related-calculations/
You also have there a section about quarter over quarter.

Showcase Report – Contoso By SpartaBI

Re: % change between previous and current quarters in power bi

Anonymous — Wed, 27 Jul 2022 01:25:19 GMT

HI Anonymous,

You can use year and quarter functions to extract the year and quarter numbers from the date field value, then you can use them in expression to get corresponding current and previous quarter values to calculate the diff.

formual = VAR currDate = MAX ( Table[Date] ) VAR prevDate = DATE ( YEAR ( currDate ), MONTH ( currDate ) - 3, DAY ( currDate ) ) VAR currQuarter = CALCULATE ( SUM ( Table[Amount] ), FILTER ( ALLSELECTED ( Table ), YEAR ( Table[Date] ) = YEAR ( currDate ) && QUARTER ( Table[Date] ) = QUARTER ( currDate ) ), VALUES ( Table[Category] ) ) VAR prevQuarter = CALCULATE ( SUM ( Table[Amount] ), FILTER ( ALLSELECTED ( Table ), YEAR ( Table[Date] ) = YEAR ( prevDate ) && QUARTER ( Table[Date] ) = QUARTER ( prevDate ) ), VALUES ( Table[Category] ) ) RETURN DIVIDE ( currQuarter - prevQuarter, prevQuarter )

Regards,

Xiaoxin Sheng