How to have a running total at any point in time with Dax and Power BI

[mariobandeira]

How do i list running bank balances ate any point in time? I do have data throught out the year but when i select a specific date in time it shows online banks with values in that specific day, i would like to list even those with no data in that day. It should show the values acummulated even when there is no values for that day.

----

Account Balance =

          VAR minDate = CALCULATE( MIN ('Nova Tesouraria'[DTMOV]),

          ALLSELECTED( 'Nova Tesouraria'[DTMOV] )

)

RETURN

CALCULATE(

     [Saldo Acumulado],

     FILTER(

            ALL( 'Nova Tesouraria'[DTMOV] ),

           'Nova Tesouraria'[DTMOV] >= minDate

           && 'Nova Tesouraria'[DTMOV] <= MAX( 'Nova Tesouraria'[DTMOV] )

     )

)

/*

[Saldo Acumulado] is a MEASURE

*/

MY DATA

----

DEBITO	CREDITO	SALDO	CONTA	DTMOV
0	60000	-60000	BFA	2019-02-04 00:00:00.000
12000	0	-48000	BFA	2019-05-04 00:00:00.000
2000000	0	1952000	BFA	2019-06-04 00:00:00.000
0	71250	1880750	BFA	2019-12-21 00:00:00.000
1419000	0	3299750	BFA	2020-02-08 00:00:00.000
602838,5	0	602838,5	BIC	2019-12-08 00:00:00.000
0	41040	561798,5	BIC	2020-01-09 00:00:00.000
2150000	0	2711799	BIC	2020-03-08 00:00:00.000
2000000	0	2000000	BPA	2019-04-04 00:00:00.000
0	190000	1810000	BPA	2019-05-04 00:00:00.000
365500	0	2175500	BPA	2019-11-08 00:00:00.000
0	72000	2103500	BPA	2020-02-09 00:00:00.000
0	108000	-108000	CXAKZ	2019-03-04 00:00:00.000
18060	0	-89940	CXAKZ	2019-03-25 00:00:00.000
8092	0	-81848	CXAKZ	2019-04-04 00:00:00.000
537500	0	455652	CXAKZ	2019-10-08 00:00:00.000
0	3420	452232	CXAKZ	2019-12-14 00:00:00.000
860000	0	1312232	CXAKZ	2020-01-08 00:00:00.000
29526	0	1341758	CXAKZ	2020-04-09 00:00:00.000

RESULT

-----

Resulta of the codeDesired Result

[lbendlin]

your sample data is missing the date column. Please add that and paste as a table, not an image.

[mariobandeira]

Hi, i did add the table with data. Thanks for the reply