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.
I'm trying to compose a text (to define the location of a file) that is made of the combination of Drilled down values (concatenated with "&")
The problem I face is that there are instances when some of this Drill down can be empty.
In Excel concatenating cells that are empty will not add anything but in PowerQuery empty is null and this ruin my formula
Are there any ways to replace this "null" by nothing in my formula ?
Solved! Go to Solution.
Text.Combine function can ignore the null value in its first parameter.
Maybe the solution by @CNENFRNL is more elegant, easier to use in case you have more columns (like I had)?
Table.AddColumn(#"Replaced Value", "Custom", each ([A]??"") & ([B]??"") & ([C]??""))
Solved: Custom column to combine two Colum returns null if... - Microsoft Fabric Community
Hey there. You can do this:
NewStep = Table.AddColumn(PriorStepName, "NewColumnName", each if [Column2] = null then [Column1] else [Column1]&[Column2], type text)
---Nate
@Hnd12000
You may try to replace null with blank using:
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Text.Combine function can ignore the null value in its first parameter.
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.