Forum Discussion

Saba_S's avatar
Saba_S
Copper Contributor
Jul 01, 2023

Power Pivot require help

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.

 

 

excel

1 Reply

Sort By
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Jul 01, 2023

    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.

Resources