Našimi kurzy prošlo více než 10 000+ účastníků
2 392 ověřených referencí účastníků našich kurzů. Přesvědčte se sami
This article describes, how to merge queries in Power Query in Power BI, when the keys in both tables are similar, but not exactly the same.
There is no need to explain, why this can be risky – on the other side it can be useful in some situations.
So how to do it?
In merging window click on Fuzzy matching and expand the window.
Now even the queries with similar values are connected.
What does what?
Number from 0 to 1. If close to 1, then only very similar matches are accepted. If close to 0, more items are connected.
When 1, only the best match is assigned, like this:
When 2, best 2 matches are assigned, like this:
If you have some table, where some values are “explained”, you can use it. It has to look like this:
2 392 ověřených referencí účastníků našich kurzů. Přesvědčte se sami
Pište kdykoliv. Odpovíme do 24h
© exceltown.com / 2006 - 2023 Vyrobilo studio bARTvisions s.r.o.