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!

itamarlopes's avatar
itamarlopes
Frequent Visitor
4 years ago

Alexis, Thanks for your answer.

I did try the cumulative totals approach before; however, it only works when the data set is relatively small.

My dataset considers a measurement every 15 minutes during a year, so I have 35,040 rows (365 days x 24 hours x 4 measurement/hour). 

I can create the measure; however, when I use it in a visual I get an error message "Can't Display the visual".

Any other idea to consider?

 

  • 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!