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.
How to use a combination of Cards and Bookmarks to filter other visualizations in Power BI.
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.
How to count all Excel cells in a range based on background color using a custom user-defined function in 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.
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.
How to display the last modified date of the underlying source Excel data file used in a Power BI report.
How to display a total and percent of total at the center of a Power BI donut chart.
How to combine clustered and stacked columns in one Excel chart without changing the source data structure.