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.
hi,
if i have created a parameter list called 'station' in power query, can i select a value from that parameter list in a dax formula? this is because i'm also using the parameter list to filter data in power query.
currently i have to hardcode a value in the dax formula as shown below-
MainAirport = "JFK"
however, i'd like to select a value from a parameter list, if possible.
kindly advise.
warmest rgds, -nik
Solved! Go to Solution.
noted with thanks again, @VijayP .
for the moment, i'm opting the simple solution using SELECTEDVALUE function and using it with a slicer.
krgds, -nik
@hood2media you can consider, but there are few limitations.
Proud to be a Super User!
noted with thanks again, @VijayP .
for the moment, i'm opting the simple solution using SELECTEDVALUE function and using it with a slicer.
krgds, -nik
@hood2media Power Query Parameters cannot be used in DAX. Alternatively you can use Field Parameters in Power BI Desktop and use them
Proud to be a Super User!
many thanks for your feedback, @VijayP.
may i kindly ask if the following meets that functional requirement-
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters ?
krgds, -nik
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |