cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gvlado
Advocate I
Advocate I

How to transform title of the data table to column

Hello
I am still learning and have a simple problem that I couldn't find the solution to.
At the top of the source table there is date i need to incorporate in the report - so how to do it with Power Query in Power BI and Excel

 
gvlado_0-1657821675545.png

Thanks in advance 
Greetings from Croatia

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

@gvlado Check if this can helps.

 

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WckksSVXSUVKK1YlWMjIwtNA1MNQ1NISJuBWVZpYUA3nO+Tn5RWChxIKCHJCOotQUML8gpzQXyC3LzM9JLQGLJGekFhVVAsWScxKLQGKxAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t]),
    #"Removed Top Rows" = Table.Skip(Source,2),
    #"Promoted Headers" = Table.PromoteHeaders(#"Removed Top Rows", [PromoteAllScalars=true]),
    GetValueFromCell = Source{1} [Column1],
    #"Added Custom" = Table.AddColumn(#"Promoted Headers", "NewColumnName", each GetValueFromCell)
in
    #"Added Custom"

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

@gvlado Check if this can helps.

 

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WckksSVXSUVKK1YlWMjIwtNA1MNQ1NISJuBWVZpYUA3nO+Tn5RWChxIKCHJCOotQUML8gpzQXyC3LzM9JLQGLJGekFhVVAsWScxKLQGKxAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t]),
    #"Removed Top Rows" = Table.Skip(Source,2),
    #"Promoted Headers" = Table.PromoteHeaders(#"Removed Top Rows", [PromoteAllScalars=true]),
    GetValueFromCell = Source{1} [Column1],
    #"Added Custom" = Table.AddColumn(#"Promoted Headers", "NewColumnName", each GetValueFromCell)
in
    #"Added Custom"

Thanks , Mohan1029 - it works
Thanks a lot.
I learned something more

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors