Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all, I´m trying to get the last month value and I can´t make it, could some body help me to get the consevutive month number or if you could help me to get the last month value I would be thankfull.
I attached the App.
Thanks!!
Try this as expression:
sum({$<[Mes-Año] = {'$(=date(addmonths(max([Mes-Año]), -1),'MMM YYYY'))'}, Mes=,Año= >}[Valor Surcharge Nuevo])
Hi,
have upated your last Month Column.
Regards Mario
Thank´s mkirchhofer but the problem is when I select January 2012 in the las month value I should get December 2011 but it returns 0.
Ok,
than use
=chr(39)&Date(MonthStart(Max([Mes-Año]))-1,'MMM YYYY')&chr(39)
at variables instead.
Try this as expression:
sum({$<[Mes-Año] = {'$(=date(addmonths(max([Mes-Año]), -1),'MMM YYYY'))'}, Mes=,Año= >}[Valor Surcharge Nuevo])
Excellent again swuehl.
Thank you both Guys!!
One more last question guys, How could I get the previous Quarter?
do you guys know it?
Did you mean something like this?
I'm not sure about performance, maybe there's a better way!
Yes!!, that´s what I needed it, Thank you both!!
Have a great one!!