Desktop - Tabular Cube - New Measure - Year on Year Cmp

[RekhaG]

Hi,

I am trying to create a new Measure in the Power Bi Desktop for year on year comparison.

My source is a tabular SSAS cube. Since a new measure cannot be created through live connection, I am using the other option of importing the fields required.

In my Time Dimension, I have a date field that is to be used for creating the new measure. But I keep getting the error message that ' A column specified in the call to function 'PARALLELPERIOD' is not of type DATE. This is not supported.'

I am confused as to why it doesnt take a date field as date. I tried using DATEVALUE function and it too didnt work.

The formula I am tried using is 

CalcClaimCount = calculate(sum(MyCube[Claim Count]),ParallelPeriod(MyCube[Time Period.Month End],-1,year))

CalcClaimCount = calculate(sum(MyCube[Claim Count]),PREVIOUSMONTH(MyCube[Time Period.Month End]))

Any help on this is appreciated.

Thanks,

Rekha

[v-haibl-msft]

@RekhaG

Please select the column of “Time Period.Month End” and make sure its type is Date as below.

One more thing, we’d better create a Calendar table and related to your table of “MyCube” with Date key when using Time Intelligence Functions.

Best Regards,

Herbert