Forum Discussion

MiguelEro's avatar
MiguelEro
Frequent Visitor
4 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

Applicable88's avatar
Applicable88
Impactful Individual
4 years ago

MiguelEro  if I understand correctly you need cumulative total. Try with that:

Measure =
calculate(sum(Sales[Total]),
Filter(
ALL('Calendar'[Date]),
'Calendar'[Date]<= MAX('Calendar'[Date])
))

 

if you additionally also want to cumulate over year by year add Max('Calendar[Year]) into it:

 

Measure =
calculate(sum(Sales[Sales]),
Filter(
ALL('Calendar'[Date]),
'Calendar'[Date]<= MAX('Calendar'[Date])
&&
('Calendar[Year]=)Max('Calendar[Year])
))

 

 

  • MiguelEro's avatar
    MiguelEro
    Frequent Visitor
    4 years ago

    thanks for your Quick response