Forum Discussion
ben_langley
2 years agoFrequent Visitor
Combining tables based on #shared output
Hi all, I'm trying to combine tables in a Power BI query based on the table name, only combining them if they are marked with a special character, in this case "*". I'm attempting to do this by g...
vanessafvg
2 years agoCommunity Champion
its actually difficult to know without seeing your data
but from what is saying i would replace your null value with a dummy value, cleary you you have column that has null values pad those with "unknown" or if a number -1 or 99 anything that would not be present in that
data. you will need to do this before your operations above
ben_langley
2 years agoFrequent Visitor
Hi Vanessa, thanks for replying. The issue also happens with the test example I've shown in the post.