Relationship between two custom DAX columns

[Kamil0]

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!

[MattAllington · Accepted 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/