Rolling 12 month in dimension

[TomBond77]

Hi experts

I would like to design a button with the following logic:

[Contract Start]={<{"$(='>=' & Monthstart(Addmonths(Max(YearMonth),-11)) & '<=' & MonthEnd(Max(YearMonth)))"}>}

YearMonth is calculated already in the KPIs and will be selected by the user, user selects e.g. 2024-Jan.

The user would like to restrict further the results by clicking on this button. 

But the above formula is incorrect, syntax error, when using it as a dimension in a table.

Any ideas how to resolve this issue?

Thanks, Tom

[Chanty4u]

Try this

[Contract Start] = {'>=' & Date(MonthStart(AddMonths(Max(YearMonth), -11)), 'YYYY-MM-DD') & '<=' & Date(MonthEnd(Max(YearMonth)), 'YYYY-MM-DD')}