Acumulated value

[Hector78]

Hello, I have a dataset like this

IDHello, I have a dataset like this

ID_PORFOLIO    F.INI_PARTIDA       FECHA INICIO INFORME       

1                        2018-01-01            2018-01-01

2                        2018-01-01            2018-01-02

3                        2018-01-01            2018-02-01

4                        2018-01-01           2018-02-03

5                       2018-01-01            2018-02-07

6                       2018-01-01            2018-03-18

7                       2018-01-01            2018-03-20

I would like to get the Number of ID_PORFOLIO acumulated at a day of (Inicio Informe).

[v-juanli-msft · Accepted solution]

Hi Hector

Is this result below meet your goal?

If so, you need create a measure as follows:

Measure =
CALCULATE (
    SUM ( Table5[ID_PORFOLIO ] ),
    FILTER (
        ALL ( Table5[FECHA INICIO INFORME] ),
        Table5[FECHA INICIO NFORME] <= MAX ( Table5[FECHA INICIO INFORME] )
    )
)

If you have any question, feel free to ask me.

Best regards

Maggie