Power Query (Excel) + M Code | How to Cell Reference - Basic but very important!

Описание к видео Power Query (Excel) + M Code | How to Cell Reference - Basic but very important!

This video will show you how to cell reference in Power Query. The techniques in the video are one of the key skills to writing advanced M code and a great way to develop exceptional excel modelling.

Topic:
0:00 - Intro
0:19 - Reference to current excel workbook
1:03 - Reference within a query
2:20 - Reference another query
2:36 - Apply reference as part of the function
2:58 - Reference a range
3:46 - Wrap up

Комментарии

Информация по комментариям в разработке

Похожие видео