Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Weekly Stock

Hi,   I would  like to create a visual that will reflect weekly movements in a specific warehouse.    Incoming Inventory stores volumes of products that come into the warehouse, by date and produ...
Need Help
Tips and Tricks
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi,

    Sorry that I misunderstood the Stock that has to actually show Stock RT.

    I fixed the Stock -> Stock RT

    Please check the link down below.

     

     

     

     

     

    https://www.dropbox.com/s/a04vwkz4dmnm3xj/9g.pbix?dl=0 

     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, Anonymous 

Please check the link down below whether it is what you are looking for.

all measures are in the sample pbix file.

 

https://www.dropbox.com/s/a04vwkz4dmnm3xj/9g.pbix?dl=0 

 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Jihwan_Kim Thank you for your response,

     

    however the solution does not fits the requirements. The main idea here is to have the stock as Running Total and once the Week filter is applied, the Total stock available in that specific week will be visible. Basically Iwant to be able to respond the following questions:

    1. What came in?
    2. What was sold?
    3. What is the total stock available for NOW (specific week) in the warehouse (specific warehouse)

     

    Thanks.

    • Jihwan_Kim's avatar
      Jihwan_Kim
      Super User
      5 years ago

      Hi,

      Sorry that I misunderstood the Stock that has to actually show Stock RT.

      I fixed the Stock -> Stock RT

      Please check the link down below.

       

       

       

       

       

      https://www.dropbox.com/s/a04vwkz4dmnm3xj/9g.pbix?dl=0 

       

      Hi, My name is Jihwan Kim.

      If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Jihwan_Kim Thanks a lot for your response.

         

        I was struggling with the quick measure for RT and didn't even thought to cut it a bit 🙂

         

        Thanks again.