Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
99 | |
86 | |
80 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |