Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

Creating Report

I have a report that I transform Data by splitting the column.  

1. Split a column by Delimiter

    a. Split column into 5 columns

2. Select or enter Dilimiter

    b. by Custom


3. Each Occurrence of the delimiter

4. Advance Options

    c. Split into


5. Number of columns to split into


6. Quote Character



Click OK


After I separated split column I need to append the Issue / Key Words to the end of the column  so I can count each issue separately. I have been appending the content for Issue/Keys Words manually.  Is it possible to append using Power BI?   Here's a sample of before appending manually:



sample of appended Issue /key words



Any help is appreciated.  


Community Champion
Community Champion

Hi @ecolema12 

It is not clear what do you mean by append!!

Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

There are 5 columns that are labeled issue /key words 1 - 5. Issue / key words 2 - 5 are appended to Issue / key words 1. 
The fields that would be used to join the issue /key words are MCP, Tracking  #, Provider Type, Responsible Tracker and Date sent to MCO.  All Issue / Keys words are in one field until I separated them. I need to count each Issue / Key words individually.    

e.g., MCP, Tracking #, Issue/ Key Words, Provider Type, Responsible Tracker, Date Sent to MCO

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.