Forum Discussion
Helper IComplex 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
Super UserPlease provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. Avoid posting screenshots of your source data if possible.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523