Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Suggested answer

How to choose date column(month, year, day) in measures

(0) ShareShare
ReportReport
Posted on by 10

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.

  • Suggested answer
    Wayne Wang Profile Picture
    Wayne Wang on at
    RE: How to choose date column(month, year, day) in measures

    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

  • LuHao Profile Picture
    LuHao 40,874 on at
    RE: How to choose date column(month, year, day) in measures

    Hi Hassina,

    I am afraid this is impossible.

    I would recommend you share this suggestion in the Ideas.

    experience.dynamics.com/.../

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,836 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans