Forum Discussion

GrahamR99's avatar
GrahamR99
Resolver I
8 years ago

Filter based on Parmeter

Hello I'm trying to do a basic query, using a Parmeter.   I have a Oracle query with results called Retail_Weeks.  I have a Parmeter called Retail_Week.   I want to have a new query with just da...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
8 years ago

GrahamR99

 

You should concatenate the string within Query part. It will be like: 

 

 

let
    Source = (Retail_Weeks,[Query="Select * From Retail_Weeks where RW_WEEK_NUMBER = ' "& Retail_Week&" ' " ])
   
in
    Source

See my sample below:

 

 

 

 

 

Regards,

GrahamR99's avatar
GrahamR99
Resolver I
8 years ago

Hello Simon Hou-MSFT

Is there any more help you can give me please, I still struggling with this problem.

 

Regards

 

GrahamR99