Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.:
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |