Circular dependancy between summarizrd table and date table

[Anonymous]

Hello  everyone, 

I have relationship between revenue date abd calendar date

i wabt to create summary table

Summary = summarize(revenuetable,calendar[date],"totalrev",calculate(sum(revenue [total]),filter(revenue, calendar[date] > DATE(2022,10,1))

After that i tried to create relationship between summary date and calendar date but error occurs curcular dependency 

[Shaurya]

Hi @Anonymous,

Why don't use Revenue Date itself to summarize and check the condition?

Summary = SUMMARIZE(RevenueTable,'RevenueTable'[Date],"TotalRev",CALCULATE(SUM(Revenue [Total]),FILTER(Revenue,'RevenueTable'[Date]>DATE(2022,10,1))

Works for you? Mark this post as a solution if it does!
Consider taking a look at my blog: Forecast Period - Previous Forecasts

[Anonymous]

it didnt work i have a relationship between calendar date and revenue date, so even when i used revnuedate it didnt work