Forum Discussion

Heather_Jones's avatar
Heather_Jones
New Member
9 years ago
Solved

Create a table in Power BI Desktop with empty text field

Hi, hoping someone can help!   I have created a table in Power BI Desktop with dtaa pulled through from queried files and I want to add an additional column where I can manually enter text (I need ...
Need Help
  • bblais's avatar
    bblais
    9 years ago

    You could create a data table that has just the primary key of your data table and a comments field, and then create a relationship between the two.  From the Edit Query page, choose the "Enter Data" button on the Home ribbon.  Then name your table and the columns, something like ID and Comments.  You should have something similar to this:

     

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUQpJLS5RcM7PzU3NK1GKjQUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [ID = _t, Comments = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"ID", Int64.Type}, {"Comments", type text}})
in
    #"Changed Type"

    Then whenever you want to comment on any record in your full data table, come to this new table in the query editor, click on the little gear to the right of the "Source" in Applied Steps, and add the row or change the comments on existing rows.  Then when you apply changes, the new comments will be available to you to use in your reports.

     

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Heather_Jones,

 

Current power bi not support direct edit the current table. I think you can try to use bblais's point of view, it seems suitable for your requirement.

 

Below are some detail steps which has the same logic:

1. Create a new table with id and comment columns.

2. Build the relationship between these tables.

3. Add a calculate column to show the related comment on original table.

 

Tables:

Original Table: ID, Type

Comment Table: ID, Comment

 

Table Formula:

Comment Table = UNION(ROW("ID",1,"Comment","Not Good"),ROW("ID",2,"Comment","Good"))

 

Calculate column:

Comment = RELATED('Comment Table'[Comment]) 

Comment(Multiple) = CONCATENATEX(FILTER(ALL('Comment Table'),'Comment Table'[ID]='Original Table'[ID]),[Comment],",")

 

Result:

 

Notice: You can add "ROW("ID",ID,"Comment","comment")" part to comment table formula to add the new comment.

 

Regards,

Xiaoxin Sheng