Combining X Number of Rows in Power Query for Power BI, Excel and Power Query Online
A while back, I was working on a project involving getting data from Excel files. The Excel files contain the…
Archive
Tag: Data Transformation
Quick Tips: Conditionally Replace Values Based on Other Values in Power Query
Power Query (M) made a lot of data transformation activities much easier and value replacement is one of them. You…
Quick Tips: How to Filter a Column by another Column from a Different Query in Power Query
A while ago I was visiting a customer that asked if they can filter a query data by a column…