Welcome to our Power Query blog. This week, I look at List.Distinct().

Welcome to our Power Query blog. This week I look at the importance of environment to Expression.Evaluate().

Welcome to our Power Query blog. This week, I look at the M function Expression.Constant().

Welcome to our Power Query blog. This week, I look at combining sheets where the columns do not match.

Welcome to our Power Query blog. This week, I look at a problem I came across when uploading a large dataset from Excel.

Welcome to our Power Query blog. This week, I look at how Power BI Desktop uses query folding in the Power Query engine.

Welcome to our Power Query blog. This week, I look at Query Folding.

Welcome to our Power Query blog. This week, I look at what to do when the location of a table is changed.

Welcome to our Power Query blog. This week, I look at how to modify a grouping statement to accommodate text fields.

Welcome to our Power Query blog. This week, I look at how to translate a range of data contained in one cell to a list of cells.