Previous Year - Measures - Non Contiguous Date Selection

[RekhaG]

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.

[BhaveshPatel]

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 · Accepted solution]

Thanks Bhavesh.

The formula below worked for me

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