Forum Discussion
Gabe_V
Helper I
3 years agoReceiving 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
Super User
3 years agoHi, 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
Helper I
3 years agoHi 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.