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...
0Anna0 you are using this feature right?
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters
yes,
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