Power Query to Access Excel Data from Current Workbook, Local File, or SharePoint
Power Query examples to access Excel data in the current workbook, local file, or SharePoint path. Data structured as a worksheet, table, or named range.
Excel
Using Cards To Filter In Power BI
How to use a combination of Cards and Bookmarks to filter other visualizations in Power BI.
Faster Excel Calculations By Minimizing Range Boundaries
Excel calculation speed can be improved by reducing the size of an evaluated range. This custom VBA function removes empty boundary cells from a range.
Counting Based on Background Color in Excel
How to count all Excel cells in a range based on background color using a custom user-defined function in VBA.
Concatenate Ranges, Arrays, and Values Using Excel VBA
How to concatenate ranges, arrays, and values in Excel using a custom function with options for a delimiter and setting row or column priority.
Excel Lookup Using Date Ranges and Multiple Criteria in Power Query
How to use Power Query to retrieve a value when the date from the first table exists between an effective date range in a second table.
Display Excel File Modified Date in Power BI
How to display the last modified date of the underlying source Excel data file used in a Power BI report.
Display Total Inside Power BI Donut Chart
How to display a total and percent of total at the center of a Power BI donut chart.
Combination Clustered and Stacked Column Chart in Excel
How to combine clustered and stacked columns in one Excel chart without changing the source data structure.