Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Calculate Sum Weirdness

Hi guys,


I'm very new to Power BI and would like to get some help.


I have linked two Excel tables in Power BI ('Growth Target') and ('Sales') with sample preview below.



Growth TargetGrowth Target



I want to create a YTD Target =  LYTD Sales + Last Month Growth Target + MTD Growth Target


The MTD Growth Target measure works just fine. The measure that I use for Last Month Growth Target is


Last Month Growth Target = calculate(sum('Growth Target'[Monthly Growth Target]),datesbetween('Growth Target'[Months],date(2017,07,01),EOMONTH(today()-1,-1)))


However this measure shows weird behaviour because when I bring them together using the Sales Table, I will get the Total of $50 Last Month Growth Target being applied to non-existing Project Codes (A-012 and A-013). What have I done wrong? Please help.







Super User II
Super User II



What do you mean by linked, did you create a relationship with an additional table?


I would be really helpful if you share a pbix by sharing a link to this pbix file, ideally pointing to the file on onedrive or dropbox.




Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Hi @thebaldkappa,


It seems you created a wrong relationship. But I can't find more without the model. Could you please provide your PBIX file? You can replace your data with dummy data. 


Best Regards!


Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!


Power Platform October Community Highlights

Check out the top community contributors across all of the communities


Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors