Forum Discussion

Sean-OReilly's avatar
Sean-OReilly
Helper IV
4 years ago
Solved

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

 

What i Want

 

 

 

 

  • 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

2 Replies

  • ITManuel's avatar
    ITManuel
    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