Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I'm stuck trying to figure out a way to apply a currency conversion within the confines of PowerQuery.
I have two tables, one containing transactions (ie: a date and a value), and one containing currency conversions in the following format:
For the life of me, I cannot come up with any way to apply these conversions to my transaction table.
To make matters worse, I ideally need to do this entirely within PowerQuery, as this step will take place before some other merges, so my previous DAX solutions are out.
Anyone know a possible way to achieve this?
In Power Query, you can merge the tables and create a custom column.
M code:
let
Source = Table.NestedJoin(Transactions, {"Date"}, Rates, {"Start Date"}, "Rates", JoinKind.LeftOuter),
ExpandRates = Table.ExpandTableColumn(Source, "Rates", {"Rate"}, {"Rate"}),
AddColumn = Table.AddColumn(ExpandRates, "Converted Amount", each [Amount] * [Rate]),
ChangeType = Table.TransformColumnTypes(AddColumn,{{"Converted Amount", type number}})
in
ChangeType
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |