Forum Discussion

RekhaG's avatar
RekhaG
Frequent Visitor
9 years ago
Solved

Previous Year - Measures - Non Contiguous Date Selection

I have created Previous Year Measure using different formulas(in Tabular SSAS Cube) as below:

but when I select them in PowerBI for non-contiguous months, nothing shows up, the service keeps shwoing 'In Progress' circle

 

PrevYear:=CALCULATE (sum( 'Table'[Column]), SAMEPERIODLASTYEAR( 'Time Period'[Month End]))

 

PrevYear:=sumx('TableName',CALCULATE([Column], DATEADD('Time Period'[Month End],-1,Year)))

 

Any help on this is appreciated.

 

Thanks.

Need Help
  • RekhaG's avatar
    RekhaG
    9 years ago

    Thanks Bhavesh.

     

    The formula below worked for me

     

    PrevYear:=CALCULATE(sum('Table'[Column]), PARALLELPERIOD('DateTable'[Date],-12,MONTH))

2 Replies

  • BhaveshPatel's avatar
    BhaveshPatel
    Super User
    9 years ago

    Hi Rekha

     

    Please try these measures for previous year calculation. Make sure you have a date table in your data model.

     

    PrevYear:=CALCULATE(SUM(Table[Column]),DATEADD('Date'[Date],-1,YEAR))

     

    OR

     

    PrevYear:=CALCULATE(SUM(Table[Column]),SAMEPERIODLASTYEAR('Date'[Date]))

     

    Thanks & Regards,

    Bhavesh

    • RekhaG's avatar
      RekhaG
      Frequent Visitor
      9 years ago

      Thanks Bhavesh.

       

      The formula below worked for me

       

      PrevYear:=CALCULATE(sum('Table'[Column]), PARALLELPERIOD('DateTable'[Date],-12,MONTH))