Circular Dependency was detected for Year-To-Date calculation
I am trying to create YTD Last Year, YTD This Year, and then a YoY calculation/column So far I have created the following columns: Max Year = max('Sales WeeklySales'[WeekEndDate].[Year]) Max Date = max('Sales WeeklySales'[WeekEndDate]) YTD TY Sales = VAR maxYear = 'Sales WeeklySales'[Max Year] VAR YTDTYStartDate = DATE(maxYear, 1, 1) VAR YTDTYEndDate = MAX('Sales WeeklySales'[Max Date]) VAR YTDSales = CALCULATE( SUM('Sales WeeklySales'[Validations]), DATESBETWEEN('Sales WeeklySales'[WeekEndDate], YTDTYStartDate, YTDTYEndDate) ) RETURN YTDSales YTD LY Start Date = VAR lastYear = max('Sales WeeklySales'[Max Year]) - 1 VAR YTDLYStartDate = DATE(lastYear,1,1) RETURN YTDLYStartDate YTD LY End Date = VAR lastYear = max('Sales WeeklySales'[Max Year]) - 1 VAR YTDLYStartDate = DATE(lastYear,1,1) VAR maxDateTY = MAX('Sales WeeklySales'[Max Date]) VAR monthDate = MONTH(maxDateTY) VAR dayDate = DAY(maxDateTY) VAR YTDLYEndDate = DATE(lastYear, monthDate, dayDate) RETURN YTDLYEndDate I am then getting an error when I come to create the following: A circular dependency was detected: Sales WeeklySales[YTD LY Sales], Sales WeeklySales[YTD TY Sales], Sales WeeklySales[YTD LY Sales]. YTD LY Sales = CALCULATE( SUM('Sales WeeklySales'[Validations]), DATESBETWEEN( 'Sales WeeklySales'[WeekEndDate], 'Sales WeeklySales'[YTD LY Start Date], 'Sales WeeklySales'[YTD LY End Date]) ) Where is the circular dependency? Thanks in advance!