Power Query - Iteratively Add Calculated Columns 🦩🦖

Описание к видео Power Query - Iteratively Add Calculated Columns 🦩🦖

A great use case for using the powerful m-query iterator function list.accumulate to dynamically add new calculated columns to a output dataset.
#dataanalytics #data #datatransformation #etl #excel #powerbi #powerquery

File Link
https://github.com/jbotes/powerbiTuto...

Noteworthy techniques
- Dynamically add columns

Functions used
List.Accumulate
https://powerquery.how/list-accumulate/

Record.Field
https://powerquery.how/record-field/

List.Skip
https://powerquery.how/list-skip/

Комментарии

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