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 😀
14 Replies
Anonymous can you share sample dataset or file for this ....as your issue is not clear
jaideepnema how can i share you please guide.
Anonymous
Upload your file on drop box or one drive and share the link 😀
here you go.
Anonymous which two tables are you trying to join and basis which column ?
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/
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 😀
I removed the unnecessary relationships and made the required relationships between the tables active .......
Appreciate a Kudos if this resolved your query !!
