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.
Hi All,
Need your suggestion on below for creating model excel is our source imported tables Actual,Budget,Project,PO and Department
I have created Date dim and join with all the tables with date column one to many
need to create below report1 and 2 as mentioned below need to join other tables not able create Active relationship and created inactive cardinality is many to many for Ex: Department
Solved! Go to Solution.
@sanjaymithran , Customer, class, Bucket and expense type are also needed as dimension
DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-soluti...
@sanjaymithran , Customer, class, Bucket and expense type are also needed as dimension
DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-soluti...
Thanks @amitchandak ,will try your suggestion and update you
Ex:You mean create Customer Dim Union all four table then join with four table with customer right ,like this we have to create separate dimension for common fields in four tables .
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.
User | Count |
---|---|
107 | |
100 | |
85 | |
77 | |
66 |
User | Count |
---|---|
120 | |
112 | |
94 | |
84 | |
75 |