How to fill out blanks in Running Total matrix Power BI

[PoojaTekriwal]

 I have used this running total for my deals column 

Deals running total in LastDay =

CALCULATE(

    SUM('PIPELINEFINAL'[Deals]),

    FILTER(

        ALLSELECTED('PIPELINEFINAL'[LastDay]),

        ISONORAFTER('PIPELINEFINAL'[LastDay], MAX('PIPELINEFINAL'[LastDay]), DESC)

    )

)

and i have only one table Pipeline and in which my lastday is

LastDay = ENDOFMONTH(PIPELINEFINAL[First Contact Date].[Date])

and rows is stageName

[V-lianl-msft]

Please refer to this:

https://stackoverflow.com/questions/53619619/how-to-fill-out-blanks-in-running-total-matrix-power-bi 

[amitchandak]

@PoojaTekriwal , Try to use date table, join that with last date

CALCULATE(
SUM('PIPELINEFINAL'[Deals]),
FILTER(
ALLSELECTED('Date'[Date]),
ISONORAFTER('Date'[Date], MAX('Date'[Date]), DESC)
)
)

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.