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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Sean-OReilly
Helper IV
Helper IV

How can I add Text to Custom Column

Hi

How do i add text to a Custom Column?

In below image from Power Bi Table I want to add a Column Called D365 Dimension Name - see Example i prepared in Excel as to what i want in Power Bi.

Essentially i want to be able to Type into Blank Cells in a Column next to an exisiting Column in a Power Bi Table.

 

Power Bi At Present

SeanOReilly_0-1659018793844.png

 

What i Want

 

SeanOReilly_1-1659018816993.png

 

 

 

1 ACCEPTED SOLUTION
ITManuel
Responsive Resident
Responsive Resident

Hi @Sean-OReilly 

 

you cannot type in cells in an additional column like in excel. You could add a conditional column and define result for certain conditions, for example IF [Division] = "Major Works" then "Major" and so on.

 

Best regards

View solution in original post

2 REPLIES 2
ITManuel
Responsive Resident
Responsive Resident

Hi @Sean-OReilly 

 

you cannot type in cells in an additional column like in excel. You could add a conditional column and define result for certain conditions, for example IF [Division] = "Major Works" then "Major" and so on.

 

Best regards

thanks for your help @ITManuel , much appreciated

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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