web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Customer experience | Sales, Customer Insights,... How to choose date col...

Customer experience | Sales, Customer Insights,...

Suggested Answer

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

(0) Share

Report

Report

Posted on by Hassina

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.

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

LuHao 40,892 on at

Like (0)

Report
Copy link

Link copied!

Hi Hassina,

I am afraid this is impossible.

I would recommend you share this suggestion in the Ideas.

experience.dynamics.com/.../

Was this reply helpful? Yes No
Suggested answer

Wayne Wang Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1

Muhammad Shahzad Sh... 69 Most Valuable Professional

#2

ManoVerse 55 Super User 2026 Season 1

#3

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans