Monday, February 8, 2021

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.

No comments:

Post a Comment