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 1 million rows of data by retailer week, and I need to remove the last week of data because it was a partial week when it was loaded. I now have a new query for last week with full data that I need to append, but I cannot figure out how to remove the partial week of data from the original query.
Solved! Go to Solution.
Hi @bradfoster,
You can filter out specific rows in Query Editor mode, similar to below if there is a date field in original table.
From above example, I filtered out records where date starts from 3/21/2018 to 3/24/2018.
Regards,
Yuliana Gu
Hi @bradfoster,
You can filter out specific rows in Query Editor mode, similar to below if there is a date field in original table.
From above example, I filtered out records where date starts from 3/21/2018 to 3/24/2018.
Regards,
Yuliana Gu
How would you go about filtering out, ie removing all rows but the first one for each row that belongs to a specific category? So for instance: let's say we have 2 categories: ( cars, planes ) and let's say we have the following columns in the table: ( datetime, category ). After sorting by datetime ascending, we want to keep the first row that shows up in the table for category 'cars', and the first row for category 'planes', deleting all the rows that come after this first row, in essence the result will be a table with 2 rows only.
How would this be done in M?
Keep Top Rows.
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |