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.