Forum Discussion
Pull all-time minimum value ignoring some external filters
I have a requirement to pull all-time minimum sales for any given area . With the help of a community member, I was able to get the current year minimum sales. The catch is that the visual already ha...
Anonymous Then try this:
All_max=var tempTable=ADDCOLUMNS(SUMMARIZE(ALL('Dates'),'Dates'[Year],'Dates'[Month Name]),"_max",[Actual Sales])
return MAXX(temptable,[_max])
Anonymous
it didn't work . I was expecting jul 2020 value (i.e 4,030,542.55) to repeat agianst each month on the visual
It's weird because for me it works as intended...