Forum Discussion

Yusissa's avatar
Yusissa
Frequent Visitor
7 years ago

Monthly Inventory

Hello Community,   I am new to power BI and Im having some isssues finding the best practice to use the dax functions in order to calculate the monthy inventory. Currently I only have the current e...
Interesting Links
v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

hi, Yusissa 

this report doesnt have any dates since it only shows the amount of stock I currently have

What is the logic to calculate Monthly Inventory? From the screenshot, we couldn't achieve it.

Sample pbix file and expected output would help tremendously. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,
Lin

 

 

  • Yusissa's avatar
    Yusissa
    Frequent Visitor
    7 years ago

    Hello Lin,

     

    Attached is the power bi file so you can better understand what im trying to achieve. 

    Power Bi file

     

    The logic is that i would like to calculate how much inventory I started with at the beginning of each month.

     

    regards,

     

    Yousef I. 

  • Yusissa's avatar
    Yusissa
    Frequent Visitor
    7 years ago

    Hello,

     

    Is the attached power bi file that I send good? Pls let me know if there is any other informacion you might need.

     

    regards

     

    Yuss