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.
Hello everyone! I'm quite new to Power BI and i have a task to solve.
Basically I have a table with Date column and User column, Date column is in dd/mm/yy hh:mm:ss format and User can appear different times during the days.
I would need to create a column with boolean values, let's say 1, if a User appears multiple times under a time interval (for instance under a minute).
I'll show a table as example:
DATE | USER | BOOL |
19/04/2020 19:30:00 | ALPHA | 0 |
19/04/2020 19:32:00 | ALPHA | 1 |
19/04/2020 19:32:30 | ALPHA | 1 |
20/04/2020 10:00:00 | ALPHA | 0 |
19/04/2020 19:32:00 | BRAVO | 1 |
19/04/2020 19:32:50 | BRAVO | 1 |
20/04/2020 11:00:00 | BRAVO | 0 |
19/04/2020 20:00:00 | CHARLIE | 0 |
19/04/2020 20:00:05 | DELTA | 0 |
I've tried several solutions found online but they do not match with my specific case.
Thanks!
Solved! Go to Solution.
Hi @A_L ,
Try this calculated column:
If you consider it as a solution, please mark as a solution and kudos.
Ricardo
Hi @A_L ,
Try this calculated column:
If you consider it as a solution, please mark as a solution and kudos.
Ricardo
Thank you! It seems to work properly in my case with a more complex and huge data table.
Kudos to you!
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |