Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

Running Product

This is the same as a running total, but it's a running product (multiplication). General formula is:

 

Running Product =
CALCULATE(
 PRODUCT('Table'[Column]),
 FILTER(
  ALLSELECTED('Table'[Column1]),
  ISONORAFTER('Table'[Column1], MAX('Table'[Column1]), DESC)
 )
)

No RepliesBe the first to reply