Exchange Rates Table
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.
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.