Forum Discussion

Casiqueno's avatar
Casiqueno
Frequent Visitor
7 years ago

Interanual comparison table

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...
 
 
Thank you very much for your help!

 

Need Help

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    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's avatar
      Casiqueno
      Frequent Visitor
      7 years ago

      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.