Lastnonblank / Fill Down with DAX Measure

Hi polestar_11 

Please try the following:

data model:

Formula:

Repeat Last Value = 

var __SelectedDate = EOMONTH(MAX(Dim_Date[PK_Date]),0)

var __LastDateWithValue =
CALCULATE(
    MAX(Fact_Sales[Date]),
    FILTER(
        ALL(Dim_Date),
        [PK_Date]<=__SelectedDate
    )
)

RETURN

CALCULATE(
    TOTALMTD([Aggregation | Sum],Dim_Date[PK_Date]),
    Dim_Date[PK_Date] = __LastDateWithValue
)

Result

Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.

Hi polestar_11 

I think I found out the reason. Please add a year column in your ddate table and filter this column on 2021. Otherwise Power BI does not know what the max date is in the formula. Please see below.

When I filter on 2021 and 2022:

when I put the filter on 2021.

so even if you only have 2021 data please add a year column in the data table and put the filter on 2021. can also be done in page filter in the visual pane.

Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.