It is even possible to send the cell contents into the WHERE clause of an SQL query in order to filter the data source instead of downloading the database and applying the filter in PwQ
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?
My pleasure, Emre. You're right. We would require VBA to automate the refresh on a cell value change. PQ only has options for timing refreshes or on workbook open.
Hey, this was amazing, but I got some issue. I did like you show, it seems to work but then it give me an error "(step 'AutoRemovedColumns1') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination." but there is no 'AutoRemovedColumns1 step. If I change it to hard coded value it work. Can you help me with this issue?
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
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]
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.
Love it! Just what I was looking for today. Greetings from South Africa
Since months I have been looking for something like this! Very useful! Thank you so much!
Glad I could help.
I had this exact situation arise recently and wasn't sure if it was possible. Thanks Alan!
Awesome! My pleasure, Brian.
Excellent demonstration of the versatility of Power Query. Great video. Thank you Alan.
Thank you, Iván
You just saved my week. Many Thanks for this wonderful video :)
No problem! Thank you.
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
Thank you Alan!
My pleasure!
It is even possible to send the cell contents into the WHERE clause of an SQL query in order to filter the data source instead of downloading the database and applying the filter in PwQ
Muito obrigado, me ajudou bastante.
Sem problemas. Bom ouvir isso
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?
My pleasure, Emre.
You're right. We would require VBA to automate the refresh on a cell value change.
PQ only has options for timing refreshes or on workbook open.
Hey, this was amazing, but I got some issue. I did like you show, it seems to work but then it give me an error "(step 'AutoRemovedColumns1') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination." but there is no 'AutoRemovedColumns1 step. If I change it to hard coded value it work. Can you help me with this issue?
Value is int64.type and it gives asked rows qty. I have query were I added index column and filtering it by 'is less than or equal to'
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
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]
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.
Thanks for the tips Jerry 👍 I use the lower case format option all the time, including in this video.