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 need to create a new table based on the actual one (see example):
serial | |
1234 | name@actualcompany.com |
1234 | name@oldcompany.com |
name@company.com | |
4321 | name@actualcompany.com |
The new one should not have duplicated serial number (we need to keep the ones with email @actualcompany.com ) and remove the ones with blank serial. So, the new table should be:
serial | |
1234 | name@actualcompany.com |
4321 | name@actualcompany.com |
Solved! Go to Solution.
In Edit Query mode, filter for actualcompany.com and Non blank Serial.
In Edit Query mode, filter for actualcompany.com and Non blank Serial.
Yes to what @amitchandak posted. Also, to make a new table right click on the query and select Reference. I presume your data is a bit more complex than your example, so remove duplicates on the serial column (or the serial column and the actual company email).
I'm not sure of the context so I have a few questions...
@freder1ck follow:
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |