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 !
I have a sales table with an INVOICEDATE field. I also have a currency history table that looks like the below image, with "valid from" and a "valid to" date. I'm trying to get the exchange rate that was effective on each INVOICEDATE of my sales table.
Could someone help ?
Thank you in advance !
Solved! Go to Solution.
Simpliest way is to use Add Column and use List.Dates in Power Query to get all the dates between the two values.
List.Dates( [Valid From], Duration.Days( [Valid To] - [Valid From] ) +1, #duration(1, 0,0,0) )
Simpliest way is to use Add Column and use List.Dates in Power Query to get all the dates between the two values.
List.Dates( [Valid From], Duration.Days( [Valid To] - [Valid From] ) +1, #duration(1, 0,0,0) )
I'm working on a very similar problem - implemented your solution, but I must be missing a trick.
It's now outputting the new column as a list - how do I then go about matching the right value to all dates in that list?
Wow !!!!! That is awesome !!!!!!!! Works perfectly. Thank you so much Nick_M !!!!
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 |
---|---|
115 | |
100 | |
88 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |