Forum Discussion

sebasjun's avatar
sebasjun
Helper 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
Helper 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
Super 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
    Helper I
    8 years ago

    Hello

     

    Thanks!  Its so very easy ...

     

    Best regards