Create Interactive Power Query Report Start & End Date

Power Query can make interactive reports with a start date and end date with a simple function query. This is not as hard as it sounds even though it involves getting into the M code a bit. The nice thing about this method is that you can then hide the data source from a user and give some basic instruction on how to use this to generate a basic report. Though it covers date selection, this method can be applied to other type of user input like text selections.

Sankey Diagram in Power BI

Sankey Diagrams show how data flows from one entity to another. You'd think that it would be difficult to create but with Power BI and the Visuals marketplace from Microsoft, you can create a simple Sankey chart to have provide some interactivity or just copy/paste to a presentation or infographic.

Google Sheets - Lookup the Last Matching Value

If you've worked with most lookup functions (like VLOOKUP, LOOKUP, etc.) it will bring back the first matching value in the range you selected. However there may be times when you want to see the last matching value from your lookups. In this video it will go through two examples of how to get the last matching value from a lookup with Google Sheets. One will be using the LOOKUP function (along with other functions) and the other will be a crazy combination of INDEX, IF, ARRAYFORMULA, ROW AND LARGE.