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