Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a fairly large CSV file that contains a flag designating domestic business versus international business. The full file contains both. What would be the best way to consume the data? I can pull it twice giving each query a different name and filtering on the column that contains the flag. Or, is there a better way to do this?
Steve
Solved! Go to Solution.
you can connect to the file once, then reference that query in 2 separate new queries - filtering one for domestic, one for international
this way whenever you change the connect file both dependants will get the latest reference
you can connect to the file once, then reference that query in 2 separate new queries - filtering one for domestic, one for international
this way whenever you change the connect file both dependants will get the latest reference
Thanks. That did work but I had to go look up how to add query2 and query3 based on query1.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |