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/powerbiTutorials/blob/main/PQ_ListAccum_NewColumns_Video.xlsx 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/