cancel
Showing results for
Did you mean:
Member

## Re: Calculating the average but also in a period

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].

Moderator

## Re: Calculating the average but also in a period

@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.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Member

## Re: Calculating the average but also in a period

@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 ?

Moderator

## Re: Calculating the average but also in a period

Hi @RvdHeijden,

Yes. Relationship should exist in Ticket table and Date table.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Member

## Re: Calculating the average but also in a period

@v-yuezhe-msft

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)

Highlighted
Moderator

## Re: Calculating the average but also in a period

Hi @RvdHeijden,

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### Back to School Contest

Engage and empower students with Power BI!

#### Watch Sessions On Demand!

Continue your learning in our online communities.

#### Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

#### PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 42 members 904 guests
Recent signins: