Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 .
User | Count |
---|---|
83 | |
69 | |
68 | |
65 | |
54 |
User | Count |
---|---|
93 | |
93 | |
91 | |
76 | |
69 |