Forum Discussion
TP-101
Helper I
Helper IExpanding a data column with mixed Text and Records
I'm attempting to expand a Record column however, there is text "Any" on some rows. Observing: Expression.Error: We cannot convert the value "Any" to type Record. (screenshots) Question, is th...
to know how to do this watch my video
https://1drv.ms/v/s!AiUZ0Ws7G26RjGrE5atu46KqC_bh?e=3oz8WT
= Table.ReplaceValue( Custom1 , each [victim], each if [victim] is text then [ [victim]] else [victim], Replacer.ReplaceValue,{"victim"})
Ahmedx
Super User
Super Userto know how to do this watch my video
https://1drv.ms/v/s!AiUZ0Ws7G26RjGrE5atu46KqC_bh?e=3oz8WT
= Table.ReplaceValue( Custom1 , each [victim], each if [victim] is text then [ [victim]] else [victim], Replacer.ReplaceValue,{"victim"})
