Forum Discussion
Drobinson1
Helper III
Helper IIIRunning balance total
I have a current inventory quantity and wanted to be able to calculate balances throughout time based on historical movement quantities. In this example I know the current starting quantity of 7....
Take a look at this:
http://www.daxpatterns.com/cumulative-total/
These starting and ending values can be calculates as measures.
I would caution using DirectQuery. Do you need the near-realtime capability? The performance will likely suffer, and you're right, you don't get to use many of DAX's more powerful functions.
https://www.sqlbi.com/tv/directquery-in-analysis-services-best-practices-performance-use-cases/
Marco Russo speaks about how and when to use DirectQuery. Maybe you'd be better off with a Live Connection instead?