Forum Discussion

anupampandey's avatar
anupampandey
Helper III
9 years ago

MTD Calculation error: A circular dependency was detected: SalesTran[Column], SalesTran[SalesYTD], S

Hi,

 

Can anyone give me suggestion that why "A circular dependency was detected: SalesTran[Column], SalesTran[SalesYTD], SalesTran[Column]." this error I am getting while calculating MTD?

 

Function I am using is SalesMTD = CALCULATE(SUM(SalesTran[Amount]),DATESMTD('Calendar'[DateKey].[Date]))

 

Thanks,

Anupam

 

Need Help

2 Replies

  • anupampandey's avatar
    anupampandey
    Helper III
    9 years ago

    Also I am using YTD = CALCULATE(SUM(SalesTran[Amount]),DATESYTD('Calendar'[DateKey].[Date],"03-31"))

     

    In above function there is a slide variation in total amount. In excel it X and in calculated field it is X+1. I don't what is wrong into this.

    • LaurentCouartou's avatar
      LaurentCouartou
      Solution Supplier
      9 years ago

      It this a measure or a calculated column? In the second case, I would expect you to get this kind of error.