Tag: Text.Split

Power BI Split Column By Delimiters In DAX

Power BI Split Column By Delimiters In DAX- Enterprise DNA

In today’s blog, you will learn how to use Power BI to split column by delimiters using DAX. This is something you would probably know how to do easily using Power Query, and that is generally the best way to do it.  But because of the dynamic nature of the problem and the specific considerations

Continue reading

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

Using Power Query Advanced Editor To Extract Values Before A Specific Text

Using Power Query Advanced Editor To Extract Values Before A Specific Text

For this tutorial, I’m going to demonstrate how you can extract values before each occurrence of a specific text using Power Query Advanced Editor. There are many ways to achieve this, but I thought it would be fun to show a solution that’s fully coded. You can watch the full video of this tutorial at

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