Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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. Actually, my company had created the Database for Sales and NPL. Of course these data are quite different in nature.
Generally, 'Sales' data consist of the total Amount and Details of each product
While the 'NPL' Data consist of outstanding of Receivables and Aging Type.
When i do these things in excel, i can simply copy the link and put it in the 'summary' sheet. But how can i do these in PowerBI?
Beside that, i can only think of the solution like this one:
Here is the link to the sample file
Combine data into one Table.xlsx
Best Regards,
Eddy W.
Solved! Go to Solution.
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
Proud to be a Datanaut!
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
Proud to be a Datanaut!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.