What Is An Implicit Measure in Power BI and Excel? An implicit measure is an aggregating calculation like a SUM or COUNT that is automatically (or implicitly!) calculated by Power BI or PivotTables in Excel. Understanding implicit measures is a…
Why Is My Power BI Merge Not Working? Merging in Power Query, whether in Excel or Power BI, is one of the core skills for your average data transformationalist (is that a word?!) In essence, the purpose of a merge…
This post discusses how to efficiently filter multiple PivotTables in Excel using Slicers, which can streamline analysis, especially in dashboards viewed by individuals unfamiliar with PivotTables. It explains the steps to create PivotTables, insert Slicers, and connect them to multiple tables, emphasizing the benefits of Slicers over traditional filters.
Creating a Pivot Table from Data on Multiple Sheets in an Excel Workbook The Problem Sometimes in a finance team we are required to combine the information on multiple sheets in an Excel workbook and then analyse the information in…
How to find White text in Excel files My SUM formula doesn’t match the total value of the cells. I can’t find some of the values in a formula. I’m a reviewer or auditor and I need to check there’s…
Trace Precedents and Trace Dependents If I change the value of this cell, how do I know which cells it will affect in my workbook? I’m in the formula bar and I want to quickly find the cells that make…
Use Control to move quickly round your Excel spreadsheet When it comes to Excel, every little helps in saving time. A really easy and very effective way to save time and be more efficient is by using keyboard shortcuts and…
You must be logged in to post a comment.