Forum Discussion

ephramz's avatar
ephramz
Icon for Helper II rankHelper II
4 years ago
Solved

Help with calculated column DAX function

Table 1: Order Number         Material Description        Quantity         Calculated Column (Total Quantity) 11111111                      Panel                              3                   ...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    ephramz , Try a new column like

     

    sumx(filter(Table, [Order Number] = earlier([Order Number]) && [Material Description] in {"Panel" , "Spacer"}),[Quantity] )

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

ephramz , Try a new column like

 

sumx(filter(Table, [Order Number] = earlier([Order Number]) && [Material Description] in {"Panel" , "Spacer"}),[Quantity] )