Forum Discussion
Need suggestion on creating Data Model
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
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-solution-8e3eccb41bda
2 Replies
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-solution-8e3eccb41bdaThanks 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 .
