Forum Discussion

sebasjun's avatar
sebasjun
Icon for Helper I rankHelper I
8 years ago
Solved

PREVIOUSMONTH not work

Hello   I have a mistery....   I have a simple table and a simple previous month calculate measure   Booking Lines PM = CALCULATE(sum(Data[Booking Lines]);PREVIOUSMONTH(Data[Booking Month].[Dat...
Need Help
  • parry2k's avatar
    parry2k
    8 years ago

    Looked at it and as suspected you have Create Month from Hoja1 table used on rows, please use "Date" column from calendar table on rows and that will do it. see image below.

     

sebasjun's avatar
sebasjun
Icon for Helper I rankHelper I
8 years ago

Hello

 

Yes! I can try reading other post. But not running 

 

Step 1: Create a Calendar datatable --> Calendar = CALENDARAUTO()

 

Step 2: Relationship

 

 

Step 3: Change Formula

Booking Lines PM = CALCULATE(sum(Data[Booking Lines]);PREVIOUSMONTH('Calendar'[Date]))

 

 

Any ideas ... 

parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

In your table what date are you using, use it from your new calendar table.

  • sebasjun's avatar
    sebasjun
    Icon for Helper I rankHelper I
    8 years ago

    Hello!

     

    Yes I  think is correct....

     

    I attach a simple file   File. If you can watch the problem

     

    Best Regards

     

     

     

     

    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      8 years ago

      Looked at it and as suspected you have Create Month from Hoja1 table used on rows, please use "Date" column from calendar table on rows and that will do it. see image below.

       

      • sebasjun's avatar
        sebasjun
        Icon for Helper I rankHelper I
        8 years ago

        Hello

         

        Thanks!  Its so very easy ...

         

        Best regards