Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi All,
I have got data in below shape:-
Data is Important | ||
Data is blah blah | ||
Data is since 01/01/2019 | ||
Column1 | Column2 | Column3 |
po | aa | 22 |
lk | bb | 3 |
I want to do below 2 things:-
a. Avoid first 4 rows since they are not part of data, just an information.
b. Still use date in 3rd row-01/01/2019 as 4th column. So that it can b used in Reporting.
Can this be done.
Regards,
RDS
Solved! Go to Solution.
Hi,
Please see if this useful. File attached as well
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WckksSVTILFbwzC3ILypJzCtR0lECoVgduNyhBQpJOYkZYAJTVqE4My85VcHAUB+IjAwMLZGUIDGd83NKc/MMgVwIywjOMgbLF+QDBRITgYSREVggJxvITkoCEkAFsQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t, Column3 = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}}), #"Removed Top Rows" = Table.Skip(#"Changed Type",4), #"Promoted Headers" = Table.PromoteHeaders(#"Removed Top Rows", [PromoteAllScalars=true]), #"Added Custom" = Table.AddColumn(#"Promoted Headers", "Date", each Text.AfterDelimiter(#"Changed Type"{2}[Column1], " ", {0, RelativePosition.FromEnd})) in #"Added Custom"
Hi,
Please see if this useful. File attached as well
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WckksSVTILFbwzC3ILypJzCtR0lECoVgduNyhBQpJOYkZYAJTVqE4My85VcHAUB+IjAwMLZGUIDGd83NKc/MMgVwIywjOMgbLF+QDBRITgYSREVggJxvITkoCEkAFsQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t, Column3 = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}}), #"Removed Top Rows" = Table.Skip(#"Changed Type",4), #"Promoted Headers" = Table.PromoteHeaders(#"Removed Top Rows", [PromoteAllScalars=true]), #"Added Custom" = Table.AddColumn(#"Promoted Headers", "Date", each Text.AfterDelimiter(#"Changed Type"{2}[Column1], " ", {0, RelativePosition.FromEnd})) in #"Added Custom"
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
71 | |
55 | |
38 | |
31 |
User | Count |
---|---|
71 | |
64 | |
60 | |
50 | |
45 |