Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
68
Views
Topic starter
Hi,
i have 2 tables:
And now i want to join them using Names but in Table2 there are named ranges as text which i have to calculate in power query.
It is possible?
Steps:
1. Join 2 tables : table1 and Table2 by Names.
2. Calculate Named ranges based on their names to get result, in this case Named1 = 1, Named2 = 2, Named3 = 3.
3.Output table
Thank you for help,
Best,
Jacek
Posted : 06/11/2019 5:33 am
You have to add a new column with this formula:
=Excel.CurrentWorkbook(){[Name=[NamedRange]]}[Content][Column1]{0}
Posted : 06/11/2019 3:01 pm
