Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi Everyone,
Wanted just to ask to the community here, if you think is possible to make a conditional merging with 2 lookup tables.
Let's say I have a data table and in this table a column (Address) with a list of addresses, but no country, only city, so I want to add a second column with the country. This information is available to me but in 2 separated lookup tables in one some addresses and in another other addresses, in the lookup tables, each address has its country in a separate column, and, I want to program the M code so that if the address of data table matches the address of lookup table1, then it gives me the country from lookup table 1, if there is no match, the code sees if there is the match in lookup table 2, if yes, then it gives me the country from lookup table 2, if also here no match for my address, then, either it leaves it blank or it writes a simple "-".
Was wondering what you think about it/if anyone thinks it is doable?
Thanks!
Stefano
You can do both merges and then coalesce the two country columns into a single column.