Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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)
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)
It works. Thank you!