Forum Discussion

Drobinson1's avatar
Drobinson1
Icon for Helper III rankHelper III
8 years ago

Running 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....
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Drobinson1,

You can not create measure or calculated column when you are using direct query, I personally suggest you use import mode. And just import the necessary data. Then create measure as the Ashish_Mathur posted. Please feel free to ask if you have any other issue.

Best Regards,
Angelia