Dax, fill down in formula

[Anonymous]

Hello everybody,

Somebody knows, how can I use Fill Down with column formula?
I have 2 column, date and value:
1. 01/01/2017 - 500
2. 01/02/2017 - blank
3. 01/03/2017 - blank
4. 01/04/2017 - 1000
5. 01/04/2017 - blank
need to:
1. 01/01/2017 - 500
2. 01/02/2017 - 500
3. 01/03/2017 - 500
4. 01/04/2017 - 1000
5. 01/04/2017 - 1000

in this situation I can't use Power Query
thanks!

[rocky09]

go to Query Editor and then

go to Transform tab

then select the column which you want to fill down

then select Fill --> Down

[Anonymous]

Thanx for answear

But i can't use Power query, because my column is returned using many tables. 

I need to use Dax

[LizBethA]

Any solution to this.  I'm trying to do the same thing!

[Anonymous · Accepted solution]

Hi, this formula will help you

Formula = 
VAR LastNonBlankDate = CALCULATE ( LASTNONBLANK ( 'Date'[Date]; 1 );
FILTER ( ALL ( 'Date'); 'Date'[Date] <= EARLIER ( 'Date'[Date] )
&& NOT ( ISBLANK ( 'Table'[Value] ) )
) )
RETURN
CALCULATE (
SUM ( 'Table'[Value] ); FILTER ( ALL ( 'Date'); 'Date'[Date] = LastNonBlankDate ))