Parameter with Query as Source

Hello rh203 

i don't know your variable SELECTED_PFR_WEEK if this is a text, list or a table. And what now is also not clear... do you want to make a DAX-statement in Power query or in Power BI?

supposing its in PowerQuery and your variable is a text

FILTER('PFR Date','PFR Date'[PFR Week]=" & 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

Hi Jimmy,

Everything in power query (excel to be precise).

The 'variable' (single value) is of type whole number.

I tried what you proposed and get the below messagw - think I understand the reason but not clear on how to pass the value into the query as a number instead?

Thanks

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

Jimmy

Hi,

No, not happy 😞

Thanks

Perfect!

Thanks for sticking with it 🙂