Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
[Contract Start] = {'>=' & Date(MonthStart(AddMonths(Max(YearMonth), -11)), 'YYYY-MM-DD') & '<=' & Date(MonthEnd(Max(YearMonth)), 'YYYY-MM-DD')}