How to make a cumulative filldown with two different measures?

[bubbledep]

Hi everyone,

I need some help to build a logic that sum the first data from "_MG_price" column (01/04/2023) with the non-blank values from the "_price" column and filldown those values.

The expected result would something like this:

01/04 - 5,2141

02/04 - 5,2141

03/04 - 5,2141+(-0,0373) = 5,1768
04/04 - 5,1768
05/04 - 5,1768
06/04 - 5,1768
07/04 - 5,1768
08/04 - 5,1768
09/04 - 5,1768
10/04 - 5,1768+(-0,0185) = 5,1583
11/04 - 5,1583
.

.

.

I tried already some builds, but none of them worked so far (both columns in that table are measures). Thank you to all in advance.

[lbendlin]

Looks like a standard running total calculation where you add _price and _MG_price of all prior dates and the current date. 

[ryan_mayu · Accepted solution]

@bubbledep 

pls see if this is what you want

Measure =

VAR _start=CALCULATE(min('Table'[Date]),ALL('Table'))

var _mg=CALCULATE([mg],FILTER(all('Table'),'Table'[Date]=_start))

var _price=sumx(FILTER(all('Table'),'Table'[Date]<=max('Table'[Date])),'Table'[_price])

return _mg+_price

pls see the attachment below

[bubbledep]

Hi @ryan_mayu , thanks for your help, that's exactly what I needed! I just adapted those ALL functions to ALLSELECT since my table is filtered, but it worked just fine.

Seems thats I was trying to do so much for a simple thing haha, thanks!

Cheers

[ryan_mayu]

you are welcome