Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm wondering where I'm going wrong with this formula. The goal is to replace the null values in "Description.2.2" with the values in "Description.1". I'm getting no errors with this formula, but it doesn't do anything at all. I've tried putting "null" in quotes, as well as without. It makes no difference.
What am I missing here?
= Table.ReplaceValue(#"Added Prefix","null", each _[Description.2.2],Replacer.ReplaceText,{"Description.1"})
Solved! Go to Solution.
Hi @barf
use the following queries
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUTIyVorViVZKBDLBDGMYowzIKCpRio0FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Description.1 = _t, Description.2.2 = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Description.1", type text}, {"Description.2.2", type text}}), #"Replaced Value" = Table.ReplaceValue(#"Changed Type","",each _[Description.1],Replacer.ReplaceValue,{"Description.2.2"}) in #"Replaced Value"
Create a new conditional column and populate values from both columns based on condition.
= Table.AddColumn(#"Changed Type", "Description 3", each if [Description 2] = null then [Description 1] else [Description 2])
Hi @barf
use the following queries
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUTIyVorViVZKBDLBDGMYowzIKCpRio0FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Description.1 = _t, Description.2.2 = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Description.1", type text}, {"Description.2.2", type text}}), #"Replaced Value" = Table.ReplaceValue(#"Changed Type","",each _[Description.1],Replacer.ReplaceValue,{"Description.2.2"}) in #"Replaced Value"
Easiest just to make a new column using similar conditional logic, rather than amending an existing one
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.