DAX

[Anonymous]

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

[Greg_Deckler]

Use the Running total quick measure. Right click a table, New quick measure

[Anonymous]

Running total is fine. But there are a few other measures to be calucated. Would need your help.

[Anonymous]

@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

[Anonymous]

I was looking two formuals.

Est Days of Cases - This is calcuating based on cases in and out values. Calucating average of the first and second month cases out multiply by est days of inv
Est Months of inventory  - this is calculating based on cases out ( average of fist and next month average)

[Anonymous]

Here is the snapshot of the sample data.

[Anonymous · Accepted solution]

@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

[Anonymous]

Can some one assist me on this DAX. This is very urgent and need to close ASAP.