Forum Discussion
Help! How do I roll forward the latest value
Hi,
No matter how I change the relationship, after deleting the relationship and re-creating a new one, it just automatically goes back to the Result table filter Calendar with many to one cardinality.😞
johnt75Super User
There should be a date column in your calendar table, with one date for each day of the years you need to cover. Link that column to a date column in your Result table. If there isn't a date column in your Result table, e.g. because there's just a year & month, create one using either DAX or Power Query set to the first day of the month and use that to link to the calendar table.
Hi ,
I have created a date ([Calendar]) in the Calendar table, and changed the column format, as below:-
and, there is a date column in my result table as well:-
when I tried to link these 2 columns, the relationship automatically changed to the Result table filter Calendar table again with Many to one cardinality. 😭😭
- johnt75
How very strange. I cannot replicate this behaviour, when I use your code it still allows me to create proper one-to-many relationships in the right direction.
The only thing I can suggest is to modify your code a little. You don't need to add the [Calendar] column as the CALENDAR function already gives you a [Date] column. Also, there is no need for the SUMMARIZE - the table is already at the granularity of one day, which is what you need, so there is nothing for SUMMARIZE to do.