Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
sanjaymithran
Helper I
Helper I

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

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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...

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@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 .

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.