Forum Discussion

rh203's avatar
rh203
Helper I
5 years ago
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...
Need Help
  • Jimmy801's avatar
    Jimmy801
    5 years ago

    this

     

    lol

     

    FILTER('PFR Date','PFR Date'[PFR Week]=VALUE(" & Text.From(SELECTED_PFR_WEEK) & ")),"
Jimmy801's avatar
Jimmy801
Community Champion
5 years ago

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

 

rh203's avatar
rh203
Helper I
5 years ago

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

 

 

  • Jimmy801's avatar
    Jimmy801
    Community Champion
    5 years ago

    Hello rh203 

    try this

    FILTER('PFR Date','PFR Date'[PFR Week]=" & Number.From(SELECTED_PFR_WEEK) & "),"
  • rh203's avatar
    rh203
    Helper I
    5 years ago

    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 '&'

     

     

     

  • Jimmy801's avatar
    Jimmy801
    Community Champion
    5 years ago

    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's avatar
    rh203
    Helper I
    5 years ago

    Hi,

     

    No, not happy 😞

     

     

    Thanks

     

     

  • Jimmy801's avatar
    Jimmy801
    Community Champion
    5 years ago

    this

     

    lol

     

    FILTER('PFR Date','PFR Date'[PFR Week]=VALUE(" & Text.From(SELECTED_PFR_WEEK) & ")),"
  • rh203's avatar
    rh203
    Helper I
    5 years ago

    Perfect!

     

    Thanks for sticking with it 🙂