hpandersen
New Member
- Joined
- Dec 12, 2018
- Messages
- 1
Hi.
I have a tabel with a lot of customer financial transactions.
One customer can easily have 100 transactions per year.
Example:
<tbody>
</tbody>
I would like to sum the different transaction per customer per year and the count how many of these summed transaction amount is >1500
In this excample, the sum amount for customer 102 is 1800 and should be counted as one.
I have made this counting in a pivot in Excel, but I really can't figure out how to do it in Power BI.
Any suggestions?
I have a tabel with a lot of customer financial transactions.
One customer can easily have 100 transactions per year.
Example:
Customer | Year | Amount |
101 | 2018 | 250 |
101 | 2018 | 500 |
101 | 2018 | 300 |
102 | 2018 | 800 |
102 | 2018 | 300 |
102 | 2018 | 700 |
103 | 2018 | 600 |
103 | 2018 | 200 |
103 | 2018 | 100 |
<tbody>
</tbody>
I would like to sum the different transaction per customer per year and the count how many of these summed transaction amount is >1500
In this excample, the sum amount for customer 102 is 1800 and should be counted as one.
I have made this counting in a pivot in Excel, but I really can't figure out how to do it in Power BI.
Any suggestions?