In today’s video I will show you how to lookup a value in the same table using power Query.
Table of contents:
00:00 Describing the example
01:08 Merge a table to itself in power query
02:30 Clean the data to keep only the rows you need
Watch the tutorial: