QoQ simple difference in Power BI

[rilonex84]

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. 

[some_bih]

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