Need suggestion on creating Data Model

[sanjaymithran]

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

[amitchandak · Accepted 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]

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 .