Forum Discussion
Gabe_V
2 years agoHelper I
Receiving errors when trying to pass and evaluate fields between functions
Hi folks, Hoping someone can help me because I'm stumped (and also kind of a newbie). I have made a custom function, and need to reference it from my main query, passing in each record and a spe...
AlienSx
2 years agoSuper User
Hi, Gabe_V do you really need a custom function? Why not simply
#"Added Custom" = Table.AddColumn(#"Flag 2b", "Flag 2 Test", each Text.Contains([DescriptionTypeValue], "(SMT)"))?
Gabe_V
2 years agoHelper I
Hi AlienSx,
That's a good question, and one that I knew would probably be asked eventually. Its mostly because this is a bare-bones version of the ultimate function, which will eventuall need to a) perform much more complex "if then" logic, and b) be able to take values from different tables' fields and compare them against each other, etc.