0

Power Pivot DAX question on stacked subtracted and summed tiers

Column W gives a simple explanation on how it should be calculated for quantity 500.. For a normal stack tier I have a working DAX formula below. However, that does not work for a stacked subtracted and summed tier.

VAR _quantity = [Quantity]
VAR _year_product = Quantity2022[YearProduct]
    RETURN
        MINX(FILTER(PriceList;
            AND(_year_product=PriceList[YearProduct];_quantity>=PriceList[QFrom]));
                PriceList[Price]*[Quantity]))

How can I do the same for a stacked tier?

Adriaan
  • 17,741
  • 7
  • 42
  • 75
CJW1960
  • 1
  • 1

0 Answers0