Customer experience | Sales, Customer Insights,...

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

(0) Share

Report

Posted on by Hassina

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.

All responses (2)

Answers (0)

Suggested answer

Wayne Wang on at

Like (0)

Report

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 40,872 on at

Like (0)

Report

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/.../