admin管理员组

文章数量:1356693

I am trying to recreate a basic Pivot table. My original pivot looks like:

My data lives in SQL and I am pulling it into PowerBI with a view.

The highlighted columns have the difference between current month and year with last year the same month. For example, the difference between March 2025 and March 2024. I have recreated all except YoY and YTD columns.

YoY =S11-F11 and YTD =T11-SUM(D11:F11) in Excel Pivot which is pretty basic. I am having trouble recreating that in PowerBI.

How could I add these 2 calculated columns to my PowerBi Matrix at the end as a single column like I have in my Pivot? I have tried creating a measure but it repeats the column after each month.

This is how my Matrix looks right now:

本文标签： powerbiRecreate a pivot on a matrixStack Overflow

版权声明：本文标题：powerbi - Recreate a pivot on a matrix - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1744064150a2584677.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。