Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
07-07-2022 06:21 AM - last edited 07-07-2022 06:29 AM
Power BI: When I asked you to create common tables: A Quick DAX Solution
Problem Statement: This is a very common scenario when you come up with two more tables and ask for
1. How to model these
2. How to avoid Many to Many joins
3. The best way to analyze this data
What I suggest to you have common tables like Item, cat, and date. Join them with these tables and analyze data together.
Refer the full solution here - https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solutio...
Check out the file for more details.