Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |