cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

 

SalesSales

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.

 

WeirdWeird

 

 

 

 

2 REPLIES 2
Super User II
Super User II

Hey,

 

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.

 

Regards

Tom



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
Microsoft
Microsoft

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!

Dale

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

Announcements
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!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

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