Forum Discussion
pass a different parameter into SQL function than what the user chooses
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
3 Replies
0Anna0 you are using this feature right?
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parametersyes,
the rgular binding to the periodcalc column is working. but i want the user to be able to choose from the period column
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
