Field parameter to calculate SAMEPERIODLASTYEAR

Question

Hi Folks,&nbsp;I was trying to use field parameter(Measure selector) to calculate SAMEPERIOLASTYEAR.&nbsp;Field parameter slicer looks like&nbsp;SalesProfitQuantity&nbsp;Measure_Prev_Year =CALCULATE (&nbsp; &nbsp; sum(field_parameter),&nbsp; &nbsp; &nbsp; &nbsp; SAMEPERIODLASTYEAR ('Calendar'[Date])&nbsp; &nbsp; )&nbsp;Now based on the selection from user on field parameter the Measure_Prev_Year measure should automatically calculate the value based on the selection.&nbsp;&nbsp;But this is not working and giving error. Not sure whether can we use field parameter measure in calculation which contains SAMEPERIODLASTYEAR function.&nbsp;&nbsp;Need suggestion on how to crack this requirement.&nbsp;

parry2k · Accepted Answer

sandeshag&nbsp;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:
&nbsp;
https://www.youtube.com/playlist?list=PLiYSIjh4cEx2s8-jXBhv5aCu5_6F9zQ3I
&nbsp;
&nbsp;

Forum Discussion

Field parameter to calculate SAMEPERIODLASTYEAR

2 Replies

Related content

SAMEPERIODLASTYEAR()

Make Parameter effective using calculated column

Issue with SAMEPERIODLASTYEAR and Manual Time Intelligence

Parameter in summarize

Filter Field Parameter by Field Parameter Values without Calculated Groups