Forum Discussion

Hnd12000's avatar
Hnd12000
Frequent Visitor
5 years ago
Solved

Composing text with null values replaced by nothing

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 som...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    5 years ago

    Text.Combine function can ignore the null value in its first parameter.

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

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 šŸ™‚

YouTube  LinkedIn