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

Hi Estefania89 you need a date Table with each day like a calendar.

 

To create a calendar table you can use:

 

Create a new Table (From Modeling)

 

CalendarTable=Calendar("01/01/2015";31/12/2016") you can change the dates according to your tables.

 

Next, create a relationship between date columns on your tables  and Calendar Table.

 

 

 

 

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 !