How can I add Text to Custom Column

[Sean-OReilly]

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

What i Want

[ITManuel · Accepted solution]

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

[Sean-OReilly]

thanks for your help @ITManuel , much appreciated