Rui Romano 8/27/2018

QuickTip – Split a delimited text into a Table in DAX

Read Original

This article provides a solution for a common DAX challenge in Power BI: converting a pipe-delimited text string into a table format. It explains how to use a combination of DAX functions (PATH, GENERATESERIES, PATHITEM, and GENERATE) to parse the text and enable row-level calculations, filling a gap where no built-in function exists.

QuickTip – Split a delimited text into a Table in DAX

Comments

No comments yet

Be the first to share your thoughts!

Browser Extension

Get instant access to AllDevBlogs from your browser

Top of the Week

2
Designing Design Systems
TkDodo Dominik Dorfmeister 2 votes
3
Introducing RSC Explorer
Dan Abramov 1 votes
5
Fragments Dec 11
Martin Fowler 1 votes
6
Adding Type Hints to my Blog
Daniel Feldroy 1 votes
7
Refactoring English: Month 12
Michael Lynch 1 votes
9