Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
@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
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |