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) & ")),"
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 🙂