Forum Discussion
DAX-Power Query | selected value from parameter
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
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
4 Replies
hood2media Power Query Parameters cannot be used in DAX. Alternatively you can use Field Parameters in Power BI Desktop and use them
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
hood2media you can consider, but there are few limitations.
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
