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].
@RvdHeijden,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 ?
Hi @RvdHeijden,Yes. Relationship should exist in Ticket table and Date table.Thanks,Lydia Zhang
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)
Hi @RvdHeijden,Could you please share me your PBIX file via Private Message?Thanks,Lydia Zhang
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!