Forum Discussion
DAX
I would like to create a cummutlative sum formulas in PowerBI
Here is the sample file : https://github.com/jangam4u/PowerBI-sample
kindly help me the DAX formulas of below measures.
| Est Days of Cases |
| Est Months of inventory |
- Anonymous6 years ago
Anonymous
Sorry for late reply, had busy days.Workfile is here: https://qiuyunus-my.sharepoint.com/:u:/g/personal/paul_qiuyunus_onmicrosoft_com/Eb-xKbgP5PlBuTLFMSeyzqMB8gLQg6A324x7gC5uxRw7Sw?e=f62Dmv
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
7 Replies
- Greg_DecklerCommunity ChampionUse the Running total quick measure. Right click a table, New quick measure
- AnonymousNot applicable
Running total is fine. But there are a few other measures to be calucated. Would need your help.
- AnonymousNot applicable
Anonymous
I see plenty of numbers in the excel. Can you clarify what are the existing columns, and what are the expecting measures with logic. You cannot just say I have this, and I want that.
Read this post to describe your sample:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490