calculate a year to date total filtered by location

[sshelton]

I have multiple locations with weekly sales and need to calculate a year to date running total for each by location.  I've tried Total YTD but it only gives me the locations sales for that week.

TOTALYTD(sum('Table 1'[Net Sales TY]),('Table 1'[Week End])

[sshelton]

Thank you - I did relook at it, and it is working when calculated using it as a Measure vs. a Column. 

[Eric_Zhang · Accepted solution]

@sshelton

What is the data like in your case? The Measure looks good and I can get running total with it in my test. If it doesn't work in your case, have you tried to use a calendar table?

[Baskar]

HI sshelton ,

This topic already discussed many time in the community.

please refer the below link

1. http://community.powerbi.com/t5/forums/searchpage/tab/message?filter=location&location=forum-board%3...

Let me know if its not solve your prob, then share your data and expected  reult , i will assit you.