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, tell me how to implement the following task in POWER BI.
Thank you!
What is:
- the date of the operation
- email (not unique)
- transaction amount
- whether the payment was confirmed or not
I need to find/calculate:
- for each user (email), the first and last transaction (amount)
- but such a "procedure" should take place no more than 15 days after the FIRST operation.
For example 1, the client made the 2nd operation 16 days after the first, then it will appear twice in the report, because more than 15 days have passed. The amount of the first and last transaction for this client will be equal.
For example 2, the client made the 2nd operation after 10 days, it will be in the report once, but with different amounts of the first and last operation.
For example 3, the client did the 2nd surgery after 3 weeks, the 3rd after 4 weeks. We need to "merge" data for 3 and 4 weeks. The client will also be in the report twice.
This is very unclear. Can you please familiarize yourself with this article first? Please always bear in mind that you know the problem you describe well but everyone here has no idea about it and you need to be very clear about what it is you want. Thanks.
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 |
---|---|
46 | |
26 | |
21 | |
12 | |
8 |
User | Count |
---|---|
75 | |
52 | |
45 | |
15 | |
12 |