Forum Discussion
best practice for Data Model (connecting tables)
Hi, Last months I was creating my first PowerBI report which is working, but I would like to improve the data model/flow for which I need some advice. The report is basically showing an overv...
Hello
what you can do is create a table using powerQuery that have the union of the SAP code of both tables
next remove the duplicates
on your model connect this table to the other 2 tables using 1 to many relation
the new table will e able to filter both table