topic Re: Keep date unchanged in a year function in App Development

Keep date unchanged in a year function

Magogar — Fri, 10 Feb 2023 08:33:39 GMT

Hi!

I'm trying to solve this problem but I can't

For any selection I make, I want to keep only the date unchanged. I tried to put {1} in the function but when I put it in autocalendar.year it doesn't work.

Sum({<[mdate.autoCalendar.Year]={"$(=Year(MonthEnd(max({1}[mdate]),-1)))"}>} ops)

How can I solve that?

Thank you!

Re: Keep date unchanged in a year function

MayilVahanan — Fri, 10 Feb 2023 08:52:07 GMT

You need to ignore the time filters like below

Sum({<[mdate.autoCalendar.Year]={"$(=Year(MonthEnd(max({1}[mdate]),-1)))"}, mdate.autoCalendar.Month=, mdate.autoCalendar.Day=,mdate=>} ops)

Re: Keep date unchanged in a year function

Magogar — Fri, 10 Feb 2023 12:27:23 GMT

It works. Thank you!