How to resume Returns and dates

[Caraneda]

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? 

[Jihwan_Kim · Accepted solution]

Hi, 

Please check the below picture and the attached pbix file.

All measures are in the attached pbix file.

[Caraneda]

Thank you very much!