Forum Discussion
Replace Null Values and If
Better use a reference table, and a custom join/lookup . No need to hard code this.
Hi Antrik,
thank you for the response. Interesting approach. I am a novice user and I'm not a programmer and I don't really understand what the code is doing, but I do not see how it is making the required changes. Thank you
Hi Centaur , Thank you for reaching out to the Microsoft Community Forum.
As mentioned by lbendlin , the most efficient way to do this is to use a reference table that stores the mapping between Vendor and Budget Category. This avoids hardcoding multiple conditions, making updates easier if new vendors are added in the future. If you prefer a simpler approach without a reference table, you can use conditional logic in Power Query to manually define rules for each Vendor. However, this method is less efficient when dealing with too many vendors, as you need to manually update the logic whenever vendors change.
I suggest using the reference table method as the latter method works but is not scalable and requires manual updates when new vendors are added.
As always, we appreciate lbendlin for your continuous contribution to the community.
If this helped solve the issue, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.
Thank you V. Appreciate the follow up confirming most efficient approach. I dont know exactly how to implement but I think i can figure it out. I might need to check a youtube video. This is my go to "advisor". I plan to tsckle today or the weekend. Thank you again for the response.
Hi Centaur , Thanks for the update. Always happy to help.