Forum Discussion
rh203
Helper I
Helper IParameter 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) & ")),"
Jimmy801
Community Champion
Community ChampionHello rh203
try this
FILTER('PFR Date','PFR Date'[PFR Week]=" & Number.From(SELECTED_PFR_WEEK) & "),"
rh203Helper I
Helper IHi,
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 '&'
- Jimmy801
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
Jimmy - rh203
Hi,
No, not happy 😞
Thanks
- Jimmy801
this
lol
FILTER('PFR Date','PFR Date'[PFR Week]=VALUE(" & Text.From(SELECTED_PFR_WEEK) & "))," - rh203
Perfect!
Thanks for sticking with it 🙂