How to display the last modified date of the underlying source Excel data file used in a Power BI report.
How to create a custom date table and year, quarter, month hierarchy in Power BI using Power Query.
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.
How to combine data from multiple data tables using DAX to create a clustered column chart in Power BI.
How to display Unicode characters and change their color in Power BI visualizations.
Tips and tricks learned from using Microsoft Power Query for Excel including performance improvements, creating total rows and running totals, handling empty tables, and filtering using named range values.
How to perform complex lookups in Excel using multiple criteria through either a formula based on the sumproduct function or an array formula.