Forum Discussion
Solved
Month over month
Good morning, i need some help with this process. i have this information for some counters, create every month and the data in cummulative. i want to know how many items i have every month. Cont...
Hi MiguelEro ,
According to my understanding, you want to calculate the difference between current month and previous month to get the actual total for each month of each Contador ,right?
Please try:
Vs Last Month = VAR _preMonth = CALCULATE ( SUM ( 'Table'[Total] ), PREVIOUSMONTH ( 'Table'[Month] ) ) RETURN IF ( _preMonth = BLANK (), BLANK (), SUM ( 'Table'[Total] ) - _preMonth )Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi MiguelEro ,
I'm not sure I completely understand the question. Can you provide an example of the desired output?
Jori
Thanks Jori, this is the spected output
ContadorMonthTotalVs Last Month
Pablo 1/1/2021 100 Pablo 2/1/2021 300 200 Pablo 3/1/2021 350 50 Pablo 4/1/2021 480 130 Pablo 5/1/2021 620 140 Pablo 6/1/2021 715 95 Pablo 7/1/2021 920 205 Pablo 8/1/2021 1021 101 Pablo 9/1/2021 1130 109 Pablo 10/1/2021 1312 182 Pablo 11/1/2021 1420 108 Pablo 12/1/2021 1550 130 Juan 1/1/2021 40 Juan 2/1/2021 70 30 Juan 3/1/2021 95 25 Juan 4/1/2021 130 35 Juan 5/1/2021 153 23 Juan 6/1/2021 180 27 Juan 7/1/2021 195 15 Juan 8/1/2021 240 45 Juan 9/1/2021 258 18 Juan 10/1/2021 274 16 Juan 11/1/2021 298 24 Juan 12/1/2021 321 23
