59 - Inner query (Power Query)
A step in Power Query can contain multiple steps. This technique uses the same logic as creating variables within a step, as a variable and a query-step are functionally identical.
This helps reduce the number of actual steps, at the cost of higher complexity within the step and a more difficult time doing debugging.
It can be a good idea if you're doing simple, obvious steps eg. add a month column, add a month-name column, add a year column etc.
00:00 Why make an inner query
00:23 Transformation steps
00:49 Creating an inner query
Within queries interlinked, within queries interlinked, within queries interlinked.
Watch video 59 - Inner query (Power Query) online without registration, duration hours minute second in high quality. This video was added by user WesleySon 11 January 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 98 once and liked it 2 people.