Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi guys,
I have data table like this
Client ID | Timestamp | Action | Step |
1 | 1 | action1 | 1 |
1 | 12 | action2 | 2 |
1 | 13 | action3 | 3 |
2 | 7 | action2 | 1 |
2 | 8 | action3 | 2 |
3 | 10 | action2 | 1 |
3 | 12 | action3 | 2 |
3 | 13 | action5 | 3 |
3 | 15 | action10 | 4 |
And I want to create a column "Step" where will be values based on unique ID and timestamp, smt like "look at the column Client ID, then look for timestamp and to the first action give 1, to the second action 2, etc" so when I want to see for example which actions users made in step 3 in the whole process, I can just filter it and to see that action3 and action5 was made once by 2 users.
Thanks
Lukas
Solved! Go to Solution.
Hi @Anonymous
Step = CALCULATE ( COUNT ( Table1[Timestamp] ), ALLEXCEPT ( Table1, Table1[Client ID] ), Table1[Timestamp] <= EARLIER ( Table1[Timestamp] ) )
Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers
Hi @Anonymous
Step = CALCULATE ( COUNT ( Table1[Timestamp] ), ALLEXCEPT ( Table1, Table1[Client ID] ), Table1[Timestamp] <= EARLIER ( Table1[Timestamp] ) )
Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers
Hi AIB,
thanks for formula but I encountered another problem. The PBIX file has only 1,3 MB (the table has only 17029 rows and 9 columns) but when I write the formula I got the error message "There's not enough memory to complete this operation. Please try again later when there may be more memory available.". I checked other threads regarding this error but I dont understand why I got it - I have 8GB RAM (in task manager I can see that BI during calculation is using 3-4 GB), I have 64-bit version of Power BI.
When I filtered some of the rows and got about 15k rows everything was just perfect. Any idea how to deal with this?
Thank you
Lukas
@Anonymous
Not really. It doesn't look like something that could cause the system to run out of memory
If you can share the pbix I'll try it on my machine
Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers
Hi AIB,
unfortunately that will not be possible for now. I have to recreate it with random numbers. But for now at least I know the answer how to do it.
Thanks again
Best
Lukas
Hi Lukas, if I undertand the issue correctly, create custom column in query editor and write code to build he new column.
cheerd
ian
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |