Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Dax, fill down in formula

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 - ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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 ))
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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 ))