results till last month

[Norbertus]

Hi, 

maybe simple, but it doesn't work for me

I have a page where the reportuser can select a year and a monthname
Now i want a visual that shows all results per month that is before the selected month

For example: Select year = 2023 and month = March

The result has to be

Januari 2023 = xxx

Febrari 2023 = xxx

March 2023 = Nothing

Measure: 

# Measure till month = 

VAR __maxdate = MAX('Dim Calendar'[Month])
VAR __Month  = 

CALCULATE(
    __maxdate,
    REMOVEFILTERS('Dim Calendar'[MonthName])
)

VAR result = 

CALCULATE(
    [# Items], 
    KEEPFILTERS(
        FILTER(
            ALL('Dim Calendar'),
            'Dim Calendar'[Year] = MAX('Dim Calendar'[Year]) && 'Dim Calendar'[Month] <= __Month
        )
    ), REMOVEFILTERS('Dim Calendar'[MonthName])
)

RETURN

result

Hope someone can help me

With kind regards

[amitchandak]

@Norbertus , Try a measure like with help from date table

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(all('Date'),'Date'[date] <=eomonth(max('Date'[date]) ,-1) ))

You can also try window function

Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc