Forum Discussion
How to replace null values with a looked up value from another table?
Hi there, my first time on the site and posting 🙂 I'm a beginning user of power query and stuck in a situation where after joins from previous tables and transformations, my combined data set ha...
NewStep=Table.ReplaceValue(PreivousStepName,each [Resource Name],"",(x,y,z)=>ReferenceTable{[#"Resource Name"=y]}?[Level 4 Director]? ??x,{"Level 4 Director"})
- Thank you wdx223_Daniel! I'll try it out right away!