Power Query has a feature that can be used to drill into details. This is particularly useful when working with 32 bit excel. Sample workbook can be downloaded here. Here are the steps. For the purposes on the tutorial let's load Sales data from an excel table (this could be from a database). Highlight Sales … Continue reading Power BI Tutorial: Drill into Details

Data for the tutorial can be obtained by downloading the following files:      Exchange Rate File Working with Currency File Step 1: Load Sales Data to Data Model Open workingwithcurrency.xlsx, highlight Sales Data table, pick PowerPivot from the ribbon and select Add to Data Model Step 2: Using Power Query to transform Exchange Rate data … Continue reading Power BI Tutorial: How to implement Currency Conversion Using Power Query and Power Pivot