Posted inData & Analysis

Splitting Text By Character Transition In Power BI And Excel Power Query

The February 2019 release of Power BI Desktop includes some new functionality not mentioned in the summary blog post, functionality that is already in the latest Excel 365 builds (thanks Ed Hansberry for pointing this out) and will be extremely useful. It takes the form of four new options under the Split Column button in the Query Editor:

Bron : Chris Webb’s BI Blog
Lees meer…

Gerelateerde artikelen:

  1. Removing Punctuation From Text With The Text.Select M Function In Power BI/Power Query/Excel Get&Transform
  2. Using Text.BetweenDelimiters() To Extract URLs From A Web Page In Power BI/Power Query M
  3. Adding Tooltips To Column Headers In The Power Query Editor In Power BI And Excel
  4. Dynamic Column Selection In Custom Columns In Power BI/Power Query/M
  5. Removing HTML Tags From Text In Power Query/Power BI
Tags: