Forum Discussion
Many-Many
Hi! In my report, there are multiple set of tables with many to many relationships. I have created bridge tables and able to solve the report. But the problem is, the data is very huge for these tab...
superpower , if you have SQL source , create a new connection and in that write a SQL to select distinct values.
Or try in DAX
Power BI- 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-solution-8e3eccb41bda