Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Fill blank cells with the right value

Hi everyone,

 

I have a dataset with customer nr. and customer name. However because my dataset is extracted from an application it can happen that if we make a invoice manually, the customer name is not included but only the customer nr. Now I want to fill in the name of the customer automatically in Power BI based on the customer nr in that row. In Excel this is pretty simple to solve by using vloopup on a list with customer numbers and the correct customer names, but how do I do this in Power BI?

 

Thanks,

Tim Hellegers

2 Replies