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.
He
Let's say i have two tables X and Y, both contains same formula “CreatedOnDate = FORMAT([createdon],”yyyy/MM/dd”)”. Now I want to connect table X with Y only based on CreatedOnDate. Sadly it's n to n relationship and i literally have no idea how to do it in Power BI (data is downloaded from Dynamic 365). As I understand i should create an another table with id's of each table X and Y so then I will be able to create one to many relationships?
Anyone can give me an example how this should be done?
Thx for help!
Solved! Go to Solution.
In the most simple deployment, simply create a new table with all the dates. Join both your current tables to the new table. Use the new table of dates for your reports, not the date columns in the current tables.
There is a world out there beyond this basic start. Here are 2 articles you may be interestedly in.
http://exceleratorbi.com.au/power-pivot-calendar-tables/
http://exceleratorbi.com.au/multiple-data-tables-power-pivot/
In the most simple deployment, simply create a new table with all the dates. Join both your current tables to the new table. Use the new table of dates for your reports, not the date columns in the current tables.
There is a world out there beyond this basic start. Here are 2 articles you may be interestedly in.
http://exceleratorbi.com.au/power-pivot-calendar-tables/
http://exceleratorbi.com.au/multiple-data-tables-power-pivot/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |