Forum Discussion
Adding column values from other table for empty cells
Hello, I'm building a table where I fetch data from an SQL database. In this table some values are empty (=null). For these empty cells I want to add values from another table, but they should o...
Hello,
thank you for the answers!
BA_Pete : Unfortunately one is SQL and the other table is Excel from a Sharepoint. Otherwise a direct SQL Query would be the best, for sure!
wdx223_Daniel : Could you explain the function a little bit? MatNr is a unique column.
I tried your proposal, but I got an error, especially the part
a{[MatNr=[MatNr]]}? ??[]is unclear to me. PowerQuery marks a as unknown, I don't know this kind of condition to look up the meaning. At first it looked like a short IF like in C, but I couldn't find anything similar, so far.
Thank you!