Field parameter to calculate SAMEPERIODLASTYEAR

[sandeshag]

Hi Folks,

I was trying to use field parameter(Measure selector) to calculate SAMEPERIOLASTYEAR.

Field parameter slicer looks like

Sales

Profit

Quantity

Measure_Prev_Year =

CALCULATE (

    sum(field_parameter),

        SAMEPERIODLASTYEAR ('Calendar'[Date])

    )

Now based on the selection from user on field parameter the Measure_Prev_Year measure should automatically calculate the value based on the selection. 

But this is not working and giving error. Not sure whether can we use field parameter measure in calculation which contains SAMEPERIODLASTYEAR function. 

Need suggestion on how to crack this requirement.

[sandeshag]

Thanks parry2k.

I was able to achieve my requirement using your video link.

https://www.youtube.com/watch?v=LSdCVbNEqcM

[parry2k · Accepted solution]

@sandeshag you cannot use field parameters to calculate it dynamically, you have to use calculation groups to achieve this. I have tons of videos on calculation groups, check out those here:

https://www.youtube.com/playlist?list=PLiYSIjh4cEx2s8-jXBhv5aCu5_6F9zQ3I