Keep date unchanged in a year function

[Magogar]

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!

[MayilVahanan · Accepted solution]

HI

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)

[Magogar]

It works. Thank you!