Filter based on Parmeter

[GrahamR99]

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 data that matches the Parmeter Retail_Week.

I have this code, but it does not work;

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

How do I change the code to make this work?

Regards

GrahamR99

[v-sihou-msft]

@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]

Hello Simon Hou-MSFT

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

Regards

GrahamR99

[GrahamR99]

Hi

Thank you for the help, but the code you have given me does not work, it comes up with the error;

Expression.SyntaxError: Token RightParen expected.

I don't know what this means, can you help any futher please?

Regards

GrahamR99