Desktop - Tabular Cube - New Measure - Year on Year Cmp
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.