Interanual comparison table

[Casiqueno]

Good afternoon experts.

I am searching for a way to somehow reproduce a table I currently maintain in Excel:

This table displays the interanual variation of a parameter (concretely waste generation).

I already have a measure for calculating the YTD:

Of course I could create a measure for each cell of the table (e.g.:

Interannual_2018_2019 = ([YTD_Total_2019]-[YTD_Total_2018])/[YTD_Total_2018]).

But I guess there should be a more effective way to achieve the result...

Link to the pbix: https://drive.google.com/file/d/1SUlSt6YVrs03omwV9xxH3i97GjTRAS9h/view?usp=sharing

Thank you very much for your help!

[v-yuta-msft]

@Casiqueno ,

I haven't found measures like [YTD_Total_2019] and [YTD_Total_2018] in your report. In addtion, the format of matrix in the excel seems to be different from that in your power bi sample report. Could you please clarify more details?

Regards,

Jimmy Tao

[Casiqueno]

@v-yuta-msft 

Thank you for addressing my post. Before uploading the pbix I cleaned it a little bit and I removed measures by error. I have uploaded a new version (the googlew drive link remains the same).

I have also updated my original post.

Concerning the difference of format between pbix and excel this is not a big issue for me indeed, my main concern is to be able to provide figures in Power BI to reflect the variation between the different years.

Thank you again!

Kind regards.