Get all YearMonths before current YearMonth

[hucand]

I'm attempting to use

=[date.autoCalendar.YearMonth]

as an expression to group sales by YearMonth.

How would I get all entries before the current month?

Thank you

[sidhiq91 · Accepted solution]

@hucand  Could you please try something like a below expression in your chart.

Sum({<[date.autoCalendar.YearMonth]={"<$(=Max([date.autoCalendar.YearMonth]))"}>}SalesAmount)

If this resolves your issue, please like and accept it as a solution.