Skip to main content
cancel
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

Reply
ecolema12
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

     Columns

5. Number of columns to split into

    5

6. Quote Character

    None

 

Click OK

ecolema12_0-1702328152272.png

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:

ecolema12_0-1702328876345.png

 

sample of appended Issue /key words

ecolema12_1-1702328966165.png

 

Any help is appreciated.  

    

2 REPLIES 2
aj1973
Community Champion
Community Champion

Hi @ecolema12 

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

Regards
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

Announcements
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.