Forum Discussion

itamarlopes's avatar
itamarlopes
Frequent Visitor
4 years ago
Solved

Using results from previous row & Eliminating a Circular Dependency

I have tried many different ways to read and use a value from a previous row, but all of them gives me the same message... "A circular dependency was detected. In a nutshell, I have a table with diff...
Need Help
  • itamarlopes's avatar
    itamarlopes
    4 years ago

    Xiao,

    I found this video from MyOnlineTrainingHub.

    https://www.youtube.com/watch?v=7kFZw8zimCU&t=461s

    Mynda Treacy explains how to create a running total to handle very large dataset in powerquery.

    The example of Running Total with with buffer works pretty well.

    I do need to adapt my model since the slicers will not be effective. I believe I can combine Power BI and PowerApps to change the inputs and recalculate the running total accordingly. 

     

    Thanks for the support!

v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
4 years ago

Hi itamarlopes 

What does it show when you click details on the error prompt?

 

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

itamarlopes's avatar
itamarlopes
Frequent Visitor
4 years ago

Xiao,

I found this video from MyOnlineTrainingHub.

https://www.youtube.com/watch?v=7kFZw8zimCU&t=461s

Mynda Treacy explains how to create a running total to handle very large dataset in powerquery.

The example of Running Total with with buffer works pretty well.

I do need to adapt my model since the slicers will not be effective. I believe I can combine Power BI and PowerApps to change the inputs and recalculate the running total accordingly. 

 

Thanks for the support!