DaveBlakeMAAT
Board Regular
- Joined
- Feb 28, 2016
- Messages
- 190
Hi
I have a parameters PQ function which is used to dynamically renames column, which is working great, however I am having trouble using the parameter in a custom column formula to reference the column name, my objective is to create the custom column so i can use to filter unwanted records.
I've tried the following:
what i am trying to achieve is a parametrized version of the following:
Thanks in advance for any assistance.
Regards
Dave
I have a parameters PQ function which is used to dynamically renames column, which is working great, however I am having trouble using the parameter in a custom column formula to reference the column name, my objective is to create the custom column so i can use to filter unwanted records.
I've tried the following:
Power Query:
if(
"[" & RPText12 & "]" = 0 and "[" & RPText11 & "]" = 0 )
then
"Remove"
else
"Keep"
if(
RPText12 = 0 and RPText11 = 0)
then
"Remove"
else
"Keep"
what i am trying to achieve is a parametrized version of the following:
Power Query:
if(
[Sep 20] = 0 and [Oct 20] = 0 )
then
"Remove"
else
"Keep"
Thanks in advance for any assistance.
Regards
Dave