Forum Discussion

rilonex84's avatar
rilonex84
New Member
3 years ago

QoQ simple difference in Power BI

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.