Forum Discussion
Solved
Help: Error; missing intermediate data.... I'm sure there IN but can't link relationship
I'm trying to merge two data sets.... by connecting NAME: Two sets of data (one for June, one for October - data has same name, I've included an index column etc...) when I try to create a relations...
- Hi Pat. You might want to look at the CALENDARAUTO() calculated table function as well. This creates a new table with all the unique dates from across your model.
Hello,
Would you mind expanding on unique? I am trying to add a date relationship between week ending date of weeks paid, week ending dates of interviews. They are all dates from 2013 to present and they are all saturdays... one table has revenue and profit data while the other has instances of interview occurrances.
Can you expand on the need for unique?
Pat
WillT
Community Admin
Community AdminHi Pat. You might want to look at the CALENDARAUTO() calculated table function as well. This creates a new table with all the unique dates from across your model.