Since months I have been looking for something like this! Very useful! Thank you so much!

Excellent demonstration of the versatility of Power Query. Great video. Thank you Alan.

I had this exact situation arise recently and wasn't sure if it was possible. Thanks Alan!

You just saved my week. Many Thanks for this wonderful video :)

Thank you Alan!

This is great! Any way to have no data in the PQ table if no selection is made? Mine defaults back to the previous selection's data

Muito obrigado, me ajudou bastante.

Alan hi, thank you for this very useful tutorial. As I see, when we change variable from the list, we have to refresh worksheet everytime to extract all values from the table. How can we automate it without clicking the refresh button?

Great video! How do I get data between two order dates? I have tried your method for the end date, but I receive an error message saying, "Expression.Error: We cannot apply operator < to types Table and Date. Details: Operator=< Left=[Table] = Table.SelectRows(#"Changed Type4", each [Patient In Room Start] >= #"Beg Date" and [Patient In Room Start]

Good day Computer gaga please direct me to your video where show how to start up excel for uk49s lotto and generator for winning numbers please Sir as I am new to learning and understanding excel🙏🙏🙏Thank you

TIP: If you NAME the cell, a Table won't be created in the Worksheet making the Worksheet neater. PQ will import the Cell's Name and make it a single row, single column table with the header Column1. Guess that's why it's called "From Table/Range"! Also, although it rarely happens, it's worth converting text in the Name and Extension columns to Lower Case in a Folder Import ti insure that all the files end with .xlsx or whatever.