Forum Discussion
Complex Calendar Table related Question
This is a general guideline. First I suggest you try and combine your pivoted tables as such:
Date | Event | No Registrations | (Cumulative) 28/05/2017 | Event A 2017 | 12 | (12) I put the cumulative in brackets as this could and should be calculated as a measure.
Then, create a relationship from a table listing the event dates. Registrations opened -date is not needed.
After that you can create a column for "Weeks before event date". Have a look at related() if you want to use a dax column. The calculation (week difference) should be easily googleable.
Please ask help for any stage of this process.Thank you Gabriel_Walkman This is perfect, thank you
This is a general guideline. First I suggest you try and combine your pivoted tables as such:
| Date | | | Event | | | No Registrations | | | (Cumulative) |
| 28/05/2017 | | | Event A 2017 | | | 12 | | | (12) |
I put the cumulative in brackets as this could and should be calculated as a measure.
Then, create a relationship from a table listing the event dates. Registrations opened -date is not needed.
After that you can create a column for "Weeks before event date". Have a look at related() if you want to use a dax column. The calculation (week difference) should be easily googleable.
Please ask help for any stage of this process.
Thank you Gabriel_Walkman This is perfect, thank you