calculate backlog from a weekly dataset

Hi , MachisukiJ 

According to your description, you want to calculate backlog from a weekly dataset, and I'm not sure exactly what your calculation logic is, but in Power BI you always calculate based on your existing data.

If you are using import mode, when the data of your data source changes, click the refresh button to automatically get the latest data and recalculate the corresponding value.

However, for Power BI datasets, there is currently no append operation and can only be calculated based on the latest value.

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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