Hi,
I've a extensive database with the following format:
| Date | Nemo | Fund | Rent |
| 1/1/2021 | Nemo1 | A | 1% |
| 1/1/2021 | Nemo1 | B | 1% |
| 1/1/2021 | Nemo1 | C | 1% |
| 1/1/2021 | Nemo2 | A | 7% |
| 1/1/2021 | Nemo2 | D | 7% |
| 1/1/2021 | Nemo3 | A | 0% |
| 1/1/2021 | Nemo3 | B | 0% |
| 1/1/2021 | Nemo3 | C | 0% |
| 1/1/2021 | Nemo3 | D | 0% |
| 2/1/2021 | Nemo1 | A | 0% |
| 2/1/2021 | Nemo1 | B | 0% |
| 2/1/2021 | Nemo1 | C | 0% |
| 2/1/2021 | Nemo2 | A | 0% |
| 2/1/2021 | Nemo2 | D | 0% |
| 2/1/2021 | Nemo3 | A | 0% |
| 2/1/2021 | Nemo3 | B | 0% |
| 2/1/2021 | Nemo3 | C | 0% |
| 2/1/2021 | Nemo3 | D | 0% |
| 3/1/2021 | Nemo1 | A | 0% |
| 3/1/2021 | Nemo1 | B | 0% |
| 3/1/2021 | Nemo1 | C | 0% |
| 3/1/2021 | Nemo2 | A | -3% |
| 3/1/2021 | Nemo2 | D | -3% |
| 3/1/2021 | Nemo3 | A | 0% |
| 3/1/2021 | Nemo3 | B | 0% |
| 3/1/2021 | Nemo3 | C | 0% |
| 3/1/2021 | Nemo3 | D | 0% |
| 4/1/2021 | Nemo1 | A | 7% |
| 4/1/2021 | Nemo1 | B | 7% |
| 4/1/2021 | Nemo1 | C | 7% |
| 4/1/2021 | Nemo2 | A | 3% |
| 4/1/2021 | Nemo2 | D | 3% |
| 4/1/2021 | Nemo3 | A | -9% |
| 4/1/2021 | Nemo3 | B | -9% |
| 4/1/2021 | Nemo3 | C | -9% |
| 4/1/2021 | Nemo3 | D | -9% |
I've daily returns for each nemotecnic in diferent fund (the nemos always have the same return in each fund per day, but not all funds have the same nemos).
I would like to resume the returns != 0% with the date of that return someting like this:
| Nemo | Rent1 | Date1 | Rent2 | Date2 | Rent3 | Date3 |
| Nemo1 | 1% | 1/1/2021 | 7% | 4/1/2021 | | |
| Nemo2 | 7% | 1/1/2021 | -3% | 3/1/2021 | 3% | 4/1/2021 |
| Nemo3 | -9% | 4/1/2021 | | | | |
Does anyone have a easy way to do this on Power BI?
