Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Circular dependency issue

  Hi,   I'm trying to build a table in Power BI which includes a rolling sum columns, but i have an issue of circular dependency. I can build it in excel woth no problem.         The ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Thanks,

    I implemeted it with Power Query iventually, using function to get the running total and then use it in User1Pct and User2Pct.

     

     

    Regards,

    Eran

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

Hi Anonymous,

In the table, User2 use the User2Pct, and User2Pct use User2, its' weird? At first, I was considering there are no User2 and the User2Pct columns in your resource table? While you must create one column based on another one? So there must be one in the begginning, but both of them depands on each other, the logic is uncorrect. Because the calculation is based on columns rather than rows. Could you please share your resouce table for further analysis?

Best Regards,
Angelia