Forum Discussion
Solved
Create Executive Summary Report From Various Data
Hello Everyone, Recently, i got task from management to create Dashboard which include sales, Non Performing loan (NPL), Total Profit, and etc. For simplicity, assume there's only sales and NPL. ...
Hi Eddy,
I think this can be achieved by creating a calendar table that aligns the common date dimensions of your two tables.
See attached at the bottom of this post a PBIX that demonstrates how to relate your tables to a common date dimension, and use matrix visuals to combine the different metrics from each table:
Pete
