Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I'm currently working on a Query in PowerBI. A condition I want to create is to grab all files that end with ".xlsx" OR ".XLSX"
I tried this:
Documents= Table.SelectRows(Source, each [Extension] = ".XLSX" or ".xlsx")
but it doesn't work as desired. Please note: I need both, simply changing the ending of the data will probably lead to problems in the future.
Just adding another line with "Documents" in the Advanced Editor doesn't work as well, Documents can only be used once.
Solved! Go to Solution.
Did you try:
Documents= Table.SelectRows(Source, each [Extension] = ".XLSX" or [Extension] = ".xlsx")
It works for me
Did you try:
Documents= Table.SelectRows(Source, each [Extension] = ".XLSX" or [Extension] = ".xlsx")
It works for me