增强查询/增强BI-将空值替换为另一列中的值 [英] Power Query / Power BI - replacing null values with value from another column

问题描述

尽管"未检测到语法错误"，但我遇到了以下错误：

Expression.Error：无法识别名称‘each_’。请确保拼写正确。

下面是几行代码，其中包括最后一行代码，这显然是由于某些原因导致的问题。 (我正在尝试将"Date"列中的空值替换为"PS Source File Name-Copy.1"列中的值)

非常感谢您的帮助。

#"Split Column by Delimiter1" = Table.SplitColumn(#"Reordered Columns", "APS Source File Name - Copy", Splitter.SplitTextByEachDelimiter({" "}, QuoteStyle.Csv, false), {"APS Source File Name - Copy.1", "APS Source File Name - Copy.2"}),
#"Changed Type3" = Table.TransformColumnTypes(#"Split Column by Delimiter1",{{"APS Source File Name - Copy.1", type date}, {"APS Source File Name - Copy.2", type text}}),
#"Reordered Columns1" = Table.ReorderColumns(#"Changed Type3",{"APS Source File Name", "APS Source File Name - Copy.2", "APS Source File Name - Copy.1", "Date"}),
#"Replaced Value" = Table.ReplaceValue(#"Reordered Columns1",null,each_({"APS Source File Name - Copy.1",Replacer.ReplaceValue},{"Date"}))

in
    #"Replaced Value"

推荐答案

尝试#"Replaced Value" = Table.ReplaceValue(#"Reordered Columns1",null, each [#"APS Source File Name - Copy.1"],Replacer.ReplaceValue,{"Date"})

这篇关于增强查询/增强BI-将空值替换为另一列中的值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！