Power Pivot require help

[Saba_S]

Hi,

I was merging two tables one from 2022 data and another one is current year;  where we have work done on each sprint.  one column is giving as respective numbers of each sprint and another column is showing total of work done (count) for the year against each sprint (say 2022 we have done 131 works;  this is showing against each sprint).  how can we bring the work done for the respective sprints.

[#2]

@Saba_S Most likely you need to fix some relationship in the Data Model and adjust the measure for "2022". Difficult to say how without seeing your data/file. Share a link (Onedrive or similar) in case you can't upload it to the forum.