I have a Calendar Table produced by PowerQueryand a data table, which currently only has two entries.
Whenever I try to create a relationship between the Calendar (marked as Date Table in PowerPivot and data type checked as Date for Date column) and the 'Date Referred' column in the data table it creates a relationship that is 1 for the data table and 'many' for the calendar table. I've checked that there are no duplicates in the calendar (which ought not be there anyway as it was created from a blank query using List.Dates in PowerQuery).
I've tried to change the direction of the relationship, but won't let me when I click on anything that appears like it should.
This seems like it should be simple, but for the life of me I can't solve it.
Any advice greatly appreciated.
Whenever I try to create a relationship between the Calendar (marked as Date Table in PowerPivot and data type checked as Date for Date column) and the 'Date Referred' column in the data table it creates a relationship that is 1 for the data table and 'many' for the calendar table. I've checked that there are no duplicates in the calendar (which ought not be there anyway as it was created from a blank query using List.Dates in PowerQuery).
I've tried to change the direction of the relationship, but won't let me when I click on anything that appears like it should.
This seems like it should be simple, but for the life of me I can't solve it.
Any advice greatly appreciated.
