I have data that is broken out by transactions by type via date as well as a user ID. I was hoping to find a way to get the count of transactions done in the same day per user ID. Further, I would like the number of User IDs that had more than 1 transaction in the same day.
Solved! Go to Solution.
I am not sure how to paste sample data but this is generally what the data is like. I want to count how mant transactions are in the same day by each user. Also I want to count how many users had 2+ transactions in the same day.
The calculation does not seem to work. It shows 3 users with more than 1 transaction in a day but only AAA and CCC did more than transaciton in a day. I am looking for specifically the count of users with subsequent transactions in the same day.
This works great, one last request: how would I get a count of the subsequetn transactions that were in the same day. So for this test data, A would have 1, C would have 2, so a count of 3 and say if A had 3 tranasctions done on the same day the count would hit 2 for a total of 4. Is this the previous calulation you did?
Sorry for the late response but the original calc does not seem to do it. I am looking for the count of subsequent transactions done in a day. So if User AAA would have had 3 transactions in one day, then 2 in another day, they would have done 3 total subsequent transactions.
Sorry, I don't understand.
"So if User AAA would have had 3 transactions in one day, then 2 in another day, they would have done 3 total subsequent transactions."
How does the 3 in one day and the 2 in another equal the 3 in total?
In this example user AAA had 2 subsequent transactions in one day, then they had one subsequent transaction on another day. This gets us our 3 total subsequent transactions.
In my use case, subsequent transaction = sum of all transactions done on the same day after the first transaction
To give some context, a process was changed to allow more than one transaction to happen in a day per user. I want to find out the sum of these subsequent transactions that are now being done that could not be done before. The first transaction could always be done, the subsequent transactions in the same day could not.
Sorry, I'm still not following.
In the summary data provided, user AAA only had one transaction on the second day, how is that considered 'subsequent' as it is the first for that day?
And for this example data, what would the subsequent transactions for CCC be?
In the example data AAA only has one subsequent transaction and CCC has 2, that is correct, for a total of 3. Sorry if it was not clear, I just wanted to explain another situation with more subsequent transactions so that you were clear what it meant. With the current data set the first calculation you did was correct in the result of 3 but the calculation was off when I tried to add more subsequent transactions. That's why I did another hyptohetical sitaution
Here is some data that should work, AAA should show 2 subsequent transactions, CCC should show 2 subsequent transactions and DDD should show 3 subsequent transactions for a total of 7.
I see that this was marked as solved by a CST member, not you.
I'm just checking, is the issue actually solved for you?
Paste some sample data (not a screenshot) that includes all these scenarios and I'm sure you'll get an answer quickly.
A screenshot of your data model would also be useful.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.