M Script Help - IF statement on Append Query

[shaunwilks]

I am wanting to use the "Advanced Editor" M- Script to optionally append one or another table based on a parameter.

So I have 3 tables PRIMARY, T1 and T2.  There is a parameter - P1. 

The PRIMARY table is the only table that will be available in the Report.

If P1 = "Table1" then the table T1 is to be appended to PRIMARY

If P2 = "Table2" then the table T2 is to be appended to PRIMARY

I have tried numerous times but cannot get the code to work - no matter what the contents of the parameter Table2 is always the one that gets added to the PRIMARY, not table 1.

Here is an example of one attempt.....

#"Appended Query1" = if ("#P1" = "Table1") then Table.Combine({Source, "T1 }) else Table.Combine({Source, "T2"})

Here is another try....

#"Appended Query1" = Table.Combine({Source, if ("#P1" = "Table1") then "T1" else "T2"})

Can someone please advise what it is I am doing wrong or provide some script that would work.

[parry2k]

let

    AppendTable = if P1 = 1 then T2 else T1,        
    Source = if P1 = 1 then T1 else T2,
    #"Appended Query" = Table.Combine({Source, AppendTable})
in
    #"Appended Query"

start with blank query, name it primary and paste above code in it. 

you can disable t1 and t2 in report loading, so you will always see primary table and will append will happen based on parameter value.

[shaunwilks]

I see the logic and its looks like it will work. The problem I am having is syntax based.

My parameter is not P1, its another term with a space in it.

The Value of the parameter is text and also has a space and so does the table name.

I made the adjustments to your code below and I get errors.

Expression.Error: We cannot convert the value "T 1" to type Table.
Details:  Value=Measures-AgeGroupsBeforePaid  Type=Type

let

AppendTable = if #"P 1"= "1" then "T 2" else "T 1",

Source = if #"P 1" = "1" then "T 1" else "T 2",

#"Appended Query" = Table.Combine({Source, AppendTable})

in

#"Appended Query"

[parry2k · Accepted solution]

let

AppendTable = if #"P 1" = "One" then #"T 2" else #"T 1",
Source = if #"P 1" = "One" then #"T 1" else #"T 2",
#"Appended Query" = Table.Combine({Source, AppendTable})
in
#"Appended Query"

[shaunwilks]

Thanks very much