Forum Discussion

Estefania89's avatar
Estefania89
New Member
10 years ago
Solved

PREVIOUSMONTH

Hello! Attempt to calculate the sales of the previous month using this function: SP= CALCULATE ( SUM ( Table1 [number ] ) ; previousMonth (Table 2 [DATA ] ) )   However, the function does not ret...
  • Vvelarde's avatar
    Vvelarde
    10 years ago

    Finally you can use your measure:

     

    SP= CALCULATE ( SUM ( Table1 [number ] ) ; previousMonth (CalendarTable [DATE ] ) )

Vvelarde's avatar
Vvelarde
Community Champion
10 years ago

Finally you can use your measure:

 

SP= CALCULATE ( SUM ( Table1 [number ] ) ; previousMonth (CalendarTable [DATE ] ) )

Estefania89's avatar
Estefania89
New Member
10 years ago

Perfect!

 

It works now. Thanks so much for all your help!

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi,

     

    I have the same problem but I already have a date table.

     

    I linked it to my sales table. The SAMEPERIODLASTYEAR function works properly but the PREVIOUSMONTH function is not working. It's giving me a blank column. Please help !

     

    Thank you !