Forum Discussion
Solved
Parameter with Query as Source
Hi, im trying to create a basic parameter to feed into a filter for a table at refresh runtime in power query. I have created a list from a table in excel and then created a parameter which u...
this
lol
FILTER('PFR Date','PFR Date'[PFR Week]=VALUE(" & Text.From(SELECTED_PFR_WEEK) & ")),"
Hello rh203
try this
FILTER('PFR Date','PFR Date'[PFR Week]=" & Number.From(SELECTED_PFR_WEEK) & "),"
Hi,
No sorry I get this message:
It looks like it ipicking up the correct value (202040) from the SELECTED_PFR_WEEK value but it is not happy with the '&'
Hello rh203
last try
FILTER('PFR Date','PFR Date'[PFR Week]=VALUE(" & SELECTED_PFR_WEEK & ")),"
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
JimmyHi,
No, not happy 😞
Thanks
this
lol
FILTER('PFR Date','PFR Date'[PFR Week]=VALUE(" & Text.From(SELECTED_PFR_WEEK) & ")),"Perfect!
Thanks for sticking with it 🙂