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.
Hi Community,
Our dataset has multiple occurences of the same logs.
We would like to create another column with a "true"/"False" marking based on wether it is a duplicate or not.
We have UserID, time of log (often twice pr day) and a column with number of logged lines.
We would like to create the extra column by looking for wether there is a similar looking record with same number of logged lines and with the same userID on the same given day.
How should we formulate the query?
Thank you in advance,
David
@Dbjerring an example of what you are talking about and the expected output in sample form will go a long way in helping the Community answer your question.
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |