Forum Discussion
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 - 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!
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 ))
4 Replies
- rocky09
Solution Sage
go to Query Editor and then
go to Transform tab
then select the column which you want to fill down
then select Fill --> Down
