ive got the 'StartDate' working but the EndDate keeps returning an error
Formula: EndDate = CALCULATE ( MAX('Date'[Date]); ALLSELECTED ( 'Date'[Date].[Date]) )
Error: A circular dependency was detected: Date[StartDate], Date[EndDate], Date[StartDate].
Create measures instead of columns using the following DAX in your date table.
StartDate = CALCULATE ( MIN ( 'Date'[Date] ); ALLSELECTED ( 'Date'[Date] ) )
EndDate = CALCULATE ( MAX('Date'[Date]); ALLSELECTED ( 'Date'[Date] ) )
Actually, you don't need to create StartDate and EndDate in your scenario, I just want to show you the number of weeks between two dates when selecting date range in Timeline.
@v-yuezhe-msft Shouldn't there be a relationship between the 'Date' table and the 'Ticket' table ?
Otherwise it wont SUM the number of tickets entered in a given week right ?
Yes. Relationship should exist in Ticket table and Date table.
Between what 2 colums should the relationship be ? i tried matching dates (one to many) between the Date table and the Ticket table but that doesn't work.
The Timeline visual doesnt even work if i have a relationship between Date (in table 'Date') and Startdatum (in table 'Tickets)
Could you please share me your PBIX file via Private Message?