Parameters

[Marico]

Hi,

I have a parameter - RevFilterActive which takes values either "TRUE" or "FALSE".

As per the earlier design, the following power query doesn't explicitly specify the value of RevFilterActive in the Advance editor. Now, I would like to understand, will this RevFilterActive actually give correct results if we don't specify the syntax like (RevFilterActive = "TRUE") inside the if statement of filtering condition?

I am trying to convert this filtering condition to native query where is it necessary to provide the value of RevFilterActive = "TRUE"/"FALSE" as mentioned below.

MT_SubQuery = "xxxxxx...",

TableObjForFilter = if RevFilterActive = "TRUE" then "Select x FROM v1 WHERE Market_Code IN ("&MT_SubQuery&") " else "Select x FROM v2",

TableObj = Value.NativeQuery(Databases(CF,WH){[Name="XX"]}[Data], "
xxxxx
Code IN ("&TableObjForFilter&")",
null, [EnableFolding=true]), 

.................................................................................................................................

Thanks for your support.

[Marico]

Can anyone help me with the above question?

@amitchandak @lbendlin @Samarth_18 @parry2k @truptis 

[lbendlin]

What happened when you tried it?