Time Function Issues

[jnaugle]

Not understanding what I am doing wrong and how to fix it. Please advise.

Thanks in advance Jamie

Previous YTD Sales =
CALCULATE(Sum(SalesDashboard[Sales_Amount_Actual]),PREVIOUSYEAR('date'[Date]))

circular dependency was detected: SalesDashboard[Previous YTD Sales], SalesDashboard[Current YTD Sales], SalesDashboard[Previous YTD Sales].

[Greg_Deckler]

@jnaugle - Very difficult to say with the information provided. Perhaps try SAMEPERIODLASTYEAR. See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...

[amitchandak]

@jnaugle , have you create your calendar using calendar auto?

Sometimes this can create an issue. So make sure it part of addcolumns. Create using calendar