Forum Discussion
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
- ITManuelResponsive 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
- Sean-OReillyHelper IV
thanks for your help ITManuel , much appreciated