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: