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.
