Hello,
I am facing quite an issue right now. I want to calcul the sum of my sales last year on the current month and fix this amout on my dashboard so that it doesn't move. The ultimate goal would be that I directly see this amout when I open my dashboard. I keep putting this formula upside down, I can't find the correct one 😞 Help
Sum({1<MyYear={"=$(=Year(Today())"} , MyMonth={"=$(=Month(Today()))"}}>} [Sales])
Also I tried to put a variable instead of Year(Today()) and Month(Today() but it still didn't work.
Also MyMonth and MyYear are the same type 1,2,3,...,12 for months and 2016,2017,2018 for years
Thanks
Ed
