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)
)
)
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
