Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Need to show current month dates in a Straight table in cloumn in dimensions tab
Data
Column A
09/04/2023
09/05/2023
30/03/2023
15/03/2023
02/04/2023
16/05/2023
Only({<[Column A] = {">=$(=MonthStart(Max([Column A])))<=$(=Max([Column A]))"}>}[Column A])
Only({<[Column A] = {">=$(=MonthStart(Max([Column A])))<=$(=Max([Column A]))"}>}[Column A])
hi,
you can try:
Only({<[Column A] = {">=$(=MonthStart(Max([Column A])))<=$(=Max([Column A]))"}>}[Column A])
Hope this helps,
help user find answers ! don't forget to mark a solution that work for you and click the like button!