The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
77 | |
75 | |
36 | |
31 | |
28 |
User | Count |
---|---|
95 | |
81 | |
55 | |
48 | |
48 |