Tag: List.Zip

Power BI Column Split Power Query Tutorial: How To Split Multi-Lined Excel Cells In Power BI

Power Query Tutorial: How To Split Multi-Lined Excel Cells In Power BI

Power Platform Tutorials In this power query tutorial, I want to show you one way of splitting multiline cells into multiple rows. Sometimes you will get an Excel file where data inside the cell is split across multiple lines. Today, I want to show you how you can use Text.Split and List.Zip to help you

Continue reading

Unpivot Multiple Columns Dynamically In Power BI

Unpivot Multiple Columns Dynamically In Power BI

In this tutorial, we’ll revisit a topic I covered earlier about how to unpivot multiple columns in Power Query using List.Zip. An Enterprise DNA member asked on the forum on how to make that method dynamic. You may watch the full video of this tutorial at the bottom of this blog. I’ve labeled this advanced

Continue reading

Power BI Unpivot Columns – Power Query Tutorial

This is a tutorial about Power BI unpivot columns. I’m going to show you how to unpivot multiple column combinations. You may watch the full video of this tutorial at the bottom of this blog. This is part of an unpivot variation series, which is all about turning your data into a proper tabular format

Continue reading

Delimited Data – Extracting Records Using Power BI

I’m going to show you how to extract records from merged delimited data within multiple columns. This turns your data into a format that’s more suitable for analysis. There are a number of ways to do this. But for this tutorial, I’m going to focus on a solution suggested by Ankit, who’s part of our

Continue reading