I have posting column in format i.e yyyy/mm/dd. when creating measure and choose posting column, it gives the option to group by year, month etc. and allow only one option. I need monthly and yearly. how to do that.
Hi Hassina,
Thanks for the question.
Currently, Dimension function only allows you to select one of the grouping options. For our future iteration, I'd like to clarify that what you want is to use the same posting column to create two dimensions, one sorted by month and the other by year.
Best,
Wayne
Hi Hassina,
I am afraid this is impossible.
I would recommend you share this suggestion in the Ideas.
André Arnaud de Cal...
291,965
Super User 2025 Season 1
Martin Dráb
230,836
Most Valuable Professional
nmaenpaa
101,156