Forum Discussion
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.
1 Reply
- some_bih
Community Champion
Hi rilonex84 , check part "Quarter-over-quarter growth" on link below https://www.daxpatterns.com/standard-time-related-calculations/