Forum Discussion
Helper IINeed suggestion on creating Data Model
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
Super Usersanjaymithran , 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
sanjaymithranThanks 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 .