Power Query - Auto-Generate Missing Rows 🧩
Автор: BA Sensei
Загружено: 2025-09-18
Просмотров: 1558
In this Power Query tutorial, you'll learn how to generate missing rows for each Name and Year combination using advanced M code. We'll use List.TransformMany, record lookups with ?, and fallback defaults with ?? to build a complete 12-month data set — even when original data is missing.
#dataanalysis #data #excel #exceltutorial #powerbi #powerquery #mquery #powerbidesktop
Follow along file
https://github.com/jbotes/powerbiTuto...
Function Page
https://powerquery.how/list-transform...
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: