Not Sure what I am doing wrong here

Question

Hello experts,&nbsp;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&nbsp;This is my relationship tab looks likeand this is how Layout tables isMeasures I have&nbsp;Appreciate your input in this.Thanks&nbsp;

amitchandak · Answer

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

baba · Answer

Thanks&nbsp;amitchandak&nbsp;Actually that option is much cleaner and less measure (again I am new to Power BI and learning new tips and tricks everyday).&nbsp;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).&nbsp;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.&nbsp;Thanks again!

baba · Answer

amitchandak&nbsp;Was able to fix the issue where past sales were not showing based on the year selected in the slicer.&nbsp; It was because of the link between tables were not correct.&nbsp;Still struggling to get the varinace between the sales.&nbsp; 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?&nbsp;Thanks&nbsp;&nbsp;

Forum Discussion

Related content

Measure Killer not working as expected. What I'm doing wrong?

Power BI doing wrong calculations

If OR statement - what am i doing wrong?

Wrong Total

Date Different return wrong value