最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

powerbi - Recreate a pivot on a matrix - Stack Overflow

programmeradmin0浏览0评论

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:

发布评论

评论列表(0)

  1. 暂无评论