Hi , i have a requirement to complete in Power Query.
Given scenario is this ,
Output Required is this :
Period | Exchange rate(euro) | Exchange rate(usd) |
4/1/2019 77.05 68.7
4/1/2018 80.1 65
and the other values are continued below. Period , exchange rates should be the column headers.
Is this possible in Power Query? I can't use DAX as i still need to model the data further , any help would be appreciated.
Hi @Anonymous
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("rZZLS8NQEIX/SrkrhTK9j9zX3u4FcRW6KBrUTQtBwZ9vqk0Xk+m5I3Q94evhy8xp+t48DuPH8dWsTbdxG29dNbt1b7bfL+/7w9uwGvefw+pu+zUe76dnciYbpQeenx5O81Qo/445tSBqseQQNEpIbyHSUUVBc5znF2xRJM2FOpS0nscc2pIq/ugcdbLDojqvy4oV2PldLrjNuA0u2wFl2oDMhoUEVdZKvpE1SFS8XAoDfLmcRkEieFvhfCUc2jKQcdROgjYETGfQENAxAVm3AwkJyFRFKBYQ8RmcqCxr0mTNFBrYTqTisInE+dV6DbcpbStjsYFKFpZhoFwkbLO5PazDQJWZjbrdgjeb0mINos4tXoNKvAk0VVAunX9Fgpt7bcFtxv1XHTqro6ZGHSQZiyUEHNZzar3Fv5fjLVt1UXEh/n2O7H4A", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column3 = _t, Column5 = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column3", type text}, {"Column5", type text}}),
#"Added Index" = Table.AddIndexColumn(#"Changed Type", "Index", 0, 1),
#"Added Custom" = Table.AddColumn(#"Added Index", "Custom", each Number.IntegerDivide([Index],3)),
#"Pivoted Column" = Table.Pivot(#"Added Custom", List.Distinct(#"Added Custom"[Column3]), "Column3", "Column5"),
#"Grouped Rows" = Table.Group(#"Pivoted Column", {"Custom"}, {{"Period", each List.Max([Period]), type text}, {"Exchange rate (Euro)", each List.Max([#"Exchange rate (Euro)"]), type text}, {"Exchange rate (USD)", each List.Max([#"Exchange rate (USD)"]), type text}}),
#"Changed Type1" = Table.TransformColumnTypes(#"Grouped Rows",{{"Exchange rate (Euro)", type number}, {"Exchange rate (USD)", type number}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type1",{"Custom"})
in
#"Removed Columns"Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Hi @Anonymous
Can you paste the sample of your data in text-taular format here (instead of screen capture) so that it can be copied easily and worked on?
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Hi @Anonymous
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("rZZLS8NQEIX/SrkrhTK9j9zX3u4FcRW6KBrUTQtBwZ9vqk0Xk+m5I3Q94evhy8xp+t48DuPH8dWsTbdxG29dNbt1b7bfL+/7w9uwGvefw+pu+zUe76dnciYbpQeenx5O81Qo/445tSBqseQQNEpIbyHSUUVBc5znF2xRJM2FOpS0nscc2pIq/ugcdbLDojqvy4oV2PldLrjNuA0u2wFl2oDMhoUEVdZKvpE1SFS8XAoDfLmcRkEieFvhfCUc2jKQcdROgjYETGfQENAxAVm3AwkJyFRFKBYQ8RmcqCxr0mTNFBrYTqTisInE+dV6DbcpbStjsYFKFpZhoFwkbLO5PazDQJWZjbrdgjeb0mINos4tXoNKvAk0VVAunX9Fgpt7bcFtxv1XHTqro6ZGHSQZiyUEHNZzar3Fv5fjLVt1UXEh/n2O7H4A", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column3 = _t, Column5 = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column3", type text}, {"Column5", type text}}),
#"Added Index" = Table.AddIndexColumn(#"Changed Type", "Index", 0, 1),
#"Added Custom" = Table.AddColumn(#"Added Index", "Custom", each Number.IntegerDivide([Index],3)),
#"Pivoted Column" = Table.Pivot(#"Added Custom", List.Distinct(#"Added Custom"[Column3]), "Column3", "Column5"),
#"Grouped Rows" = Table.Group(#"Pivoted Column", {"Custom"}, {{"Period", each List.Max([Period]), type text}, {"Exchange rate (Euro)", each List.Max([#"Exchange rate (Euro)"]), type text}, {"Exchange rate (USD)", each List.Max([#"Exchange rate (USD)"]), type text}}),
#"Changed Type1" = Table.TransformColumnTypes(#"Grouped Rows",{{"Exchange rate (Euro)", type number}, {"Exchange rate (USD)", type number}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type1",{"Custom"})
in
#"Removed Columns"Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Helpful resources
Power BI Monthly Update - April 2026
Check out the April 2026 Power BI update to learn about new features.
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
FabCon & SQLCon Highlights
Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.
