Forum Discussion
Select Row Values by column Selection
sammy02hk , you have to unpivot the first table and bring Promotion Name on rows and then you can join and filter
Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g
Hi sammy02hk,
Did you intend to accomplish this task?
If so, utilizing a many-to-many relationship between the Article Sales and Promotion Table is an option. I am attaching the modeling view for your reference here.
Warm regards,
Riddhesh
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Riddhesh
Thank you for your reply.
For the promotion table, is it impossible to stay in this form.
And need to transform to his format?
Since @the Database, Article No and Promtion No are in great amounts, I try to reduce the database size.
Thank you.
Hello sammy02hk,
Yes, you need to transform your promotion table. It's recommended to organize your data model by separating it into fact tables and dimension tables. The amount of data should not be an issue as long as the database is properly designed. A database is capable of managing a large volume of data, including millions of rows.
Additionally, a well-structured data model is crucial for optimal performance in Power BI.
Thank you
Thank you for you help.