Dax Running Total By Year

[dhsilv2]

Hi all,

I hope this is the right forum, I'm attempting to create a formula in power pivot to show a running total. I however want to be able to compare the running total through each month and week today year over year.

=calculate(
sum(ReceiptsDat[LocalCurrncy2+]),
filter(all(WeekMap[Date]),'WeekMap'[Date] <= Max (WeekMap[Date])))

This was my first attempt, but as I'm removing filters, this includes data from prior years and doesn't allow me to filter for the year.

Ultimately I'm attempting to graph this showing money received (ReceiptsDat table) by week (defined by the WeekMap table) and month (also defined by WeekMap) and to also show it cumulatively.

Any help would be greatly appreciated and hopefully this is the right place for this question.

 

[Matador56]

Have you solved this one yet? I can help but would need to know the format of your WeekMap table in order to use the correct formulas. Are you able to provide a sample perhaps of this table?