Forum Discussion
DAX
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
Running total is fine. But there are a few other measures to be calucated. Would need your help.
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
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)Here is the snapshot of the sample data.
Can some one assist me on this DAX. This is very urgent and need to close ASAP.