Daily final amount average

[KristinaSp]

Hello,

Could you help me with dax formula.

I need to calculate simple average of daily cummulative final amount as shown in the example below:

Date	Inflow	Outflow	Final amount	Cummulative final
2021-01-01	100	-50	50	50
2021-01-02	200		200	250
2021-01-03	300	-200	100	350
2021-01-04		-50	-50	300
2021-01-05		-200	-200	100
2021-01-06	500		500	600
2021-01-07	496	-150	346	946
2021-01-08	300		300	1246
2021-01-09	5616	-3468	2148	3394
2021-01-10	16		16	3410
2021-01-11			0	3410
			Dayly average	1278

[Ashish_Mathur]

Hi,

What does your source data look like?  Do you simply want to show 1,278 on a card visual?

[KristinaSp]

Hi, thanks for propt reaction. It could be a measure, there is no need to see every day result.

Iš will be in the table by category

[Ashish_Mathur]

You have answered my second question - that you want to see the result in a card visual.  Please answer the first one - share your source data which i can copy into an MS Excel workbook.  Else, share the download link of your PBI file.

[KristinaSp]

Hello, this is teh pbix with this example:
https://drive.google.com/file/d/1SHLxOLa8J5eoZqtW-p_HnsikoWdBKJpQ/view?usp=sharing 

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.