cancel
Showing results for 
Search instead for 
Did you mean: 

Running Product

Super User
693 Views
Highlighted
Super User
Super User

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)
 )
)


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!