Not Sure what I am doing wrong here

[Baba]

Hello experts,

I am trying to get this layout and able to do that if I don't link my "Layout" table to "Sales" table but all the sales numbers are repeating.

but if I link those two together (Header from Layout and Sales Type from Sales) calculation is correct but delta colums disappears 

This is my relationship tab looks like

and this is how Layout tables is

Measures I have

 

Appreciate your input in this.

Thanks

[Baba]

@amitchandak

Was able to fix the issue where past sales were not showing based on the year selected in the slicer.  It was because of the link between tables were not correct.

Still struggling to get the varinace between the sales.  I used this below measure to test and it's working as long as slicer stays to "2023" but need help how I can switch to selected year in the slicer?

Thanks

[amitchandak]

@Baba, Can try creating a calculation group if there are measures.

[Baba]

Thanks @amitchandak 

Actually that option is much cleaner and less measure (again I am new to Power BI and learning new tips and tricks everyday).

So after using "Calculation Group" (with in the power bi because I don't have Tabular Editor because of IT limitations) I am able to get (sort of) what I am after but two questions:

1. Since I am using slicer to choose the year, so I'd like to show past N years depending on which years is selected in the slicer and I can only able to get one (in this case last column on the matrix changes depending on the year).

2. Would like to show (at the very end of the matrix) change in sales depending on the year is selected in the slicer. (E.g.: if user select 2024 in the slicer, I want to show change in sales (subtraction) previous year (int his example 2023) minus slicer year (in this example 2024). same thing if 2023 is selected should show (2023 sales minus 2022) so on and so forth.

Thanks again!