Forum Discussion

SuperCal99's avatar
SuperCal99
Helper I
4 years ago
Solved

Complex Calendar Table related Question

Hi, Bit of a complex calendar related table question which I hope someone can help me with.   I have a request to create a line graph showing the number of registrations into a variety of differ...
Need Help
  • Gabriel_Walkman's avatar
    Gabriel_Walkman
    4 years ago

    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.