Forum Discussion
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
Anonymous
Using LOOKUPVALUE function:
Example:
RetrieveCountry = LOOKUPVALUE(MasterTable[Country],MasterTable[State],EmployeeInformation[State])
Link:
https://www.c-sharpcorner.com/article/dax-in-power-bi-how-to-use-lookupvalue-function/
2 Replies
- themistoklis
Community Champion
Anonymous
Using LOOKUPVALUE function:
Example:
RetrieveCountry = LOOKUPVALUE(MasterTable[Country],MasterTable[State],EmployeeInformation[State])
Link:
https://www.c-sharpcorner.com/article/dax-in-power-bi-how-to-use-lookupvalue-function/
- v-juanli-msft
Community Support
Hi Anonymous
Based on my test, themistoklis's suggestion should be useful.
You need to create a new column with correct customer names using this formula.
If you have any problem implementing this in your scenario, please let me know.
Best Regards
Maggie