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
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.
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