Unpivot Columns based on Condition in Power Query and Power BI

Описание: Unpivot columns dynamically if the column name contains a specific text.

This cannot be done from the UI of Power Query, we need to manipulate the M code with some smart M Language functions.

#powerbi #powerquery #dataanalytics #datamodeling