Exchange Rates Table While creating a report spanning a wide range of dates with values form multiple currencies I was looking for a way to get the rate per day and currency. Here’s the solution I created using Power Query.
Sum column based on criteria while grouping in Power Query. A little trick I created once while working with some data.
Your Name (required)
Your Email (required)
© 2021. Created by YMI Data Solutions. Powered by WordPress