Forum Discussion

Iamnvt's avatar
Iamnvt
Continued Contributor
8 years ago
Solved

Sales - stock Calculation

hi,   I have a Sales table: Order      Date               Product  Sales 1 11/25/2017 A 10 2 11/26/2017 B 20 3 11/27/2017 A 5   and a Stock table: Product    Quantity ...
Need Help
DAX0110's avatar
DAX0110
Resolver V
8 years ago

Hi Iamnvt, if you begin by creating a measure that sums the total product sales for each product before the current date, then you will quickly arrive at a simple formula for Material Requirement.

Iamnvt's avatar
Iamnvt
Continued Contributor
8 years ago
Hi,

It is not working when you put the date field into the pivot.

Br
  • DAX0110's avatar
    DAX0110
    Resolver V
    8 years ago

    Hi Iamnvt, can you upload the sample file elsewhere?  I can't download it from the current host.

    • Iamnvt's avatar
      Iamnvt
      Continued Contributor
      8 years ago

      it is Onedrive link. My friend can download it well. Could you please try again? DAX0110

      • DAX0110's avatar
        DAX0110
        Resolver V
        8 years ago

        Hi Iamnvt, I did some work on your sample workbook - please see:

         

        Modified workbook