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.
Sample Power BI Report – Online marketplaces settlements report This is a copy of an actual report (recreated using fictitious data) built on data from settlement reports from multiple marketplaces.
Sum column based on criteria while grouping in Power Query. A little trick I created once while working with some data.