cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RekhaG
Frequent Visitor

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

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

1 REPLY 1
v-haibl-msft
Microsoft
Microsoft

@RekhaG

 

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

Desktop - Tabular Cube - New Measure - Year on Year Cmp_1.jpg

 

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.

Desktop - Tabular Cube - New Measure - Year on Year Cmp_2.jpg

 

Desktop - Tabular Cube - New Measure - Year on Year Cmp_3.jpg

 

Best Regards,

Herbert

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.