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 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.
The rewind feature brings new life to classic and impossibly difficult NES games on Nintendo Switch Online.
How to create cascading drop-down lists in Excel. Selecting an option in the parent cell filters the available options in the dependent child cell.