Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.