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.

Anonymous's avatar
Anonymous
Not applicable
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.

  • MiguelEro's avatar
    MiguelEro
    Frequent Visitor
    4 years ago

    Thanks Anonymous , this is just what i was looking for.

    Apreciate your help.