pass a different parameter into SQL function than what the user chooses

[0Anna0]

i have  sql function which accepts some kind of timeline parameter which retrives me a table in a period of time. the sql funcftion can only accept the values which in the PeriodCalc cloumn. is there a way for the user to pick a value from a slicer that contains the values from the Period column  but  the actual value that will be pass to the SQL would be from the PeriodCalc cloumn?

(example: user picks 3Y from the slicer but the SQL gets 3.00)

using the m query bind to parameter 

[SpartaBI]

@0Anna0 you are using this feature right?
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters

[0Anna0]

yes,

the rgular binding to the periodcalc column is working. but i want the user to be able to choose from the period column

[SpartaBI]

I think you can try and twick the sql statement in the M code, and add sone sql logic to change from the value the user selected to the value eventually be in the final output