Forum Discussion
Retail Store Sale & Closing Inventory Relation Management
Hi, I am trying to link 2 tables Sales and Closing Inventory by Season-Gender-Category but its not working i have applied slicer but it sorts only Sale or Stock. Regards, Ammar
Anonymous Change the relationships as shown below:
Hope that helps !!
Please accept this as a soluion if this resolved your query !! Appreciate a Kudos also 😀
Anonymous , I am assuming these are the common dimensions
Season , Gender and Category and you are creating a star schema -https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/
https://www.seerinteractive.com/blog/join-many-many-power-bi/