Archive for May 2014

Use Power Query to Calculate Distance

Barbara Raney May 18, 2014 Microsoft Excel, Microsoft Excel 2013, Power BI Desktop, Power Pivot, Power Query (M) Comments Off on Use Power Query to Calculate Distance

Distance calculations! Over the past couple of years, I have had several clients who are using PowerPivot who want to measure the distance between two points on a map: Client to distribution center or building to building. For just a…Continue Reading →

Use Power Query to Inventory your files

Barbara Raney May 11, 2014 DAX, Microsoft Excel, Microsoft Excel 2010, Microsoft Excel 2013, Power BI Desktop, Power Pivot, Power Query (M) Comments Off on Use Power Query to Inventory your files

Welcome to GirlsWithPowerTools.com! If you found this blog expecting to find scantily clad ladies with buzz saws, boy have you come to the wrong place! If you would like to learn more about the great suite of tools that Microsoft…Continue Reading →