Forum Discussion

Alanlu's avatar
Alanlu
New Member
3 years ago

Strange circular dependency issue

Hi guys, I have encountered some strange circular dependency error which I do not see any connection between each section. TG (Plan) has already been calculated using plan number - current sa...
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

Alanlu , In case both, are columns try

 

[Le] - [CY Rev]

Alanlu's avatar
Alanlu
New Member
3 years ago

amitchandak It's not working as I expected.

maybe I should explain a bit more regarding the format of the data.

[CY rev] contains multiple posting dates and customer#

[AOP] and [LE] are allocated monthly only.

I would like to see the to-go value va AOP and LE for MTD, QTD and YTD.

Thanks

    • Alanlu's avatar
      Alanlu
      New Member
      3 years ago

      amitchandak the formula for TG(Plan) is below

      TG (Plan) = CALCULATE(SUM('sales'[AOP])-CALCULATE(SUM('sales'[CY rev])))
      I tried the formula for TG(LE) as below
      TG (LE) = CALCULATE(SUM('sales'[LE])-CALCULATE(SUM('sales'[CY rev])))
       
      it did mentioned similar in the video but I cannot add 'allexcept' in the formula, so maybe should try some ways?
       This is all the columns I have in the table