Forum Discussion

Nick1810's avatar
Nick1810
Frequent Visitor
6 years ago
Solved

Inventory Availability Coverage

Hello, I have a table RK_InventarioHistorico like this:   Product Warehouse Quantity A California 2 A Miami 0 B California 0 B Miami 0 C California 0 C Miami 1 ...
Need Help
  • JarroVGIT's avatar
    JarroVGIT
    6 years ago

    Sorry I linked to the wrong file. The file is here:

    https://1drv.ms/u/s!Ancq8HFZYL_aiJBRfsmli39RRmqCOA?e=5Uo1n3 

    There is an Inventory table and a YesNo table. 

     

    Kind regards

    Djerro123

    -------------------------------

    If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

    Keep those thumbs up coming! 🙂

Nick1810's avatar
Nick1810
Frequent Visitor
6 years ago

Hi edhans,

 

Thanks for the reply.

Yes, the results are for ANY warehouse. I tried this, but I found I have another problem. Obviusly, the example was a simplification, but the reality is that the Inventory table is a History Inventory, so the Products are repeated for every month because it is a "picture" of the inventory at the end of each month. I use a Calendar Table to relate dates.

The Inventory Table, in fact, looks like this:

 

ProductWarehouseQuantityReport Date
ACalifornia2ene-20
AMiami0ene-20
BCalifornia0ene-20
BMiami0ene-20
CCalifornia0ene-20
CMiami1ene-20
DCalifornia10ene-20
DMiami4ene-20
ACalifornia0dic-19
AMiami0dic-19
BCalifornia1dic-19
BMiami0dic-19
CCalifornia0dic-19
CMiami0dic-19
DCalifornia5dic-19
DMiami9dic-19

 

And the results I would like to get are these:

 

 On Hand
DateYesNo
ene-2075%25%
dic-1950%50%

 

Thanks!

 

Nicolas.

 

 

 

JarroVGIT's avatar
JarroVGIT
Resident Rockstar
6 years ago
My measure solution would work in your new requirement, doesn't it? Make a matrix visual, put YesNo column as columns, put date as rows and the measure as values? That's why I made a measure solution as well 🙂
  • Nick1810's avatar
    Nick1810
    Frequent Visitor
    6 years ago
    Hi!
    I downloaded your file, but I could not find the calculated measure. Only tables from other examples. Which name is the measure?

    Thanks!
    • JarroVGIT's avatar
      JarroVGIT
      Resident Rockstar
      6 years ago

      Sorry I linked to the wrong file. The file is here:

      https://1drv.ms/u/s!Ancq8HFZYL_aiJBRfsmli39RRmqCOA?e=5Uo1n3 

      There is an Inventory table and a YesNo table. 

       

      Kind regards

      Djerro123

      -------------------------------

      If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

      Keep those thumbs up coming! 🙂

      • Nick1810's avatar
        Nick1810
        Frequent Visitor
        6 years ago

        Hi Djerro123,

         

        Based on that file I could manage to solve my report

         

        Many Thanks!!