cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gvlado
Frequent Visitor

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
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.