Hello I want to find the cumulative production of one column, like this:
How can I make the cummulative column?
Go to Solution.
Hi @OscarSuarez10 ,
Try this calculated Column:
Calculated Column =
VAR PreviousRow =
RUnn[Year] < EARLIER ( RUnn[Year] )
VAR PreviousValue =
MINX ( PreviousRow, [Production] )
RUnn[Production] + PreviousValue
*RUnn is my table name
Here is what I get:
Let me know if this works.
Try this formula to create a measure
Measure = var _prevalue=CALCULATE(SUM('Table'[Prouction]),FILTER(ALL('Table'),'Table'[Year]=MAX('Table'[Year])-1)) return
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.