Blog

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.

Online Marketplaces Settlements Report

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

Sum column based on criteria while grouping in Power Query. A little trick I created once while working with some data.