QoQ simple difference in Power BI

rilonex84 — Wed, 24 May 2023 16:16:08 GMT

Hi All -
In Excel i have the below simple QoQ and YTD change (=L5 - K5)

How do i calculate the simple QoQ percentage change (example: Q1 - Q4) in Power BI, If I am using 3 DataTable 'Broad Asset Class Mapping', 'ICC Report' and a calculated 'Date' table.

I am using a matrix table for my power BI.

I am using Broad Asset Class column as rows which is under 'Broad Asset Class Mapping' table .

I am using Category and Asset Class columns also as rows which are under 'ICC Report' table.

I am using Dollar column in Values which is under ' ICC Report' table and Dollar is set as percentage of column total.

I am using Year and Quarter in columns which are under 'Date' table.

Thank you for your assistance.

Re: QoQ simple difference in Power BI

some_bih — Mon, 29 May 2023 12:13:35 GMT

Hi rilonex84 , check part "Quarter-over-quarter growth" on link below https://www.daxpatterns.com/standard-time-related-calculations/

topic Re: QoQ simple difference in Power BI in DAX Commands and Tips

QoQ simple difference in Power BI

Re: QoQ simple difference in Power BI