Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi my Friends, I need your help, I have the next measure
=(Sum({<[YearPeriod] = {"2021"},[ACCNT_CODE]={"10*","36*"}>}[AMOUNT]*-1)
+ (sum({<[YearPeriod] = {">=1844 <=2020"},[ACCNT_CODE]={"10*","36*"}>}[AMOUNT]*-1)))
And shows the following graph
It shows me the monthly balance but I want it to show me in January the result of the sum of December + January, in February the result of the sum of January + February, in March the result of the sum of February + March etc.
Ex. January 8,944,830.98 - 511,809.44 = 8,433,021.54
February 8,433,021.54 + 3,917,866.98 = 12,350,888.50
March 12,350,888.50 + 171,594.98 = 12,522,483.50 etc.
Thank your help.
Hi,
I think you are going to need to do something like;
RangeSum(Above(Sum( ... Your Measure ...),0,2))
You might need to tweak your set analysis depending on how the numbers come together for Dec/Jan at the start.
Cheers,
Chris.
Yes My Friend, I have to change the meseure, but This work with you answer... thank you very much...
(RangeSum(Above(Sum({<[YearPeriod] = {">=1844 <=$(=YearPeriod)"}, [ACCNT_CODE]={"10*","36*"}>}[AMOUNT]*-1), 0, RowNo())))
Hi,
I think you are going to need to do something like;
RangeSum(Above(Sum( ... Your Measure ...),0,2))
You might need to tweak your set analysis depending on how the numbers come together for Dec/Jan at the start.
Cheers,
Chris.
Hi my Friend, I tried but don't work, just advanced one month...
Yes My Friend, I have to change the meseure, but This work with you answer... thank you very much...
(RangeSum(Above(Sum({<[YearPeriod] = {">=1844 <=$(=YearPeriod)"}, [ACCNT_CODE]={"10*","36*"}>}[AMOUNT]*-1), 0, RowNo())))