I'm trying to compose a text (to define the location of a file) that is made of the combination of Drill 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 their ways to replace this "null" by nothing in my formula ?
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 their ways to replace this "null" by nothing in my formula ?
