Forum Discussion

Caraneda's avatar
Caraneda
Frequent Visitor
5 years ago
Solved

How to resume Returns and dates

Hi, 

 

I've a extensive database with the following format:

DateNemoFundRent
1/1/2021Nemo1A1%
1/1/2021Nemo1B1%
1/1/2021Nemo1C1%
1/1/2021Nemo2A7%
1/1/2021Nemo2D7%
1/1/2021Nemo3A0%
1/1/2021Nemo3B0%
1/1/2021Nemo3C0%
1/1/2021Nemo3D0%
2/1/2021Nemo1A0%
2/1/2021Nemo1B0%
2/1/2021Nemo1C0%
2/1/2021Nemo2A0%
2/1/2021Nemo2D0%
2/1/2021Nemo3A0%
2/1/2021Nemo3B0%
2/1/2021Nemo3C0%
2/1/2021Nemo3D0%
3/1/2021Nemo1A0%
3/1/2021Nemo1B0%
3/1/2021Nemo1C0%
3/1/2021Nemo2A-3%
3/1/2021Nemo2D-3%
3/1/2021Nemo3A0%
3/1/2021Nemo3B0%
3/1/2021Nemo3C0%
3/1/2021Nemo3D0%
4/1/2021Nemo1A7%
4/1/2021Nemo1B7%
4/1/2021Nemo1C7%
4/1/2021Nemo2A3%
4/1/2021Nemo2D3%
4/1/2021Nemo3A-9%
4/1/2021Nemo3B-9%
4/1/2021Nemo3C-9%
4/1/2021Nemo3D-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:

 

NemoRent1Date1Rent2Date2Rent3Date3
Nemo11%1/1/20217%4/1/2021  
Nemo27%1/1/2021-3%3/1/20213%4/1/2021
Nemo3-9%4/1/2021    

 

 

Does anyone have a easy way to do this on Power BI? 

dataset
DATATABLE

2 Replies