Acumulated value

Question

Hello, I have a dataset like thisIDHello, I have a dataset like thisID_PORFOLIO&nbsp; &nbsp; F.INI_PARTIDA&nbsp; &nbsp; &nbsp; &nbsp;FECHA INICIO INFORME&nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2018-01-01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2018-01-012&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2018-01-01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2018-01-023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2018-01-01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2018-02-014&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2018-01-01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2018-02-035&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2018-01-01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2018-02-076&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2018-01-01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2018-03-187&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2018-01-01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2018-03-20I would like to get the Number of ID_PORFOLIO acumulated at a day of (Inicio Informe).

v-juanli-msft · Accepted Answer

Hi HectorIs this result below meet your goal?If so, you need create a measure as follows:&nbsp;&nbsp;Measure =
CALCULATE (
    SUM ( Table5[ID_PORFOLIO ] ),
    FILTER (
        ALL ( Table5[FECHA INICIO INFORME] ),
        Table5[FECHA INICIO NFORME] &lt;= MAX ( Table5[FECHA INICIO INFORME] )
    )
)If you have any question, feel free to ask me.Best regardsMaggie

Forum Discussion

Acumulated value

1 Reply

Related content

Acumulative Percentaje

Acumulate fortnight

Show acumulated values

Acumulated value using measures for YTD

Acumulative totals in matrix cels