Dax Running Total By Year

dhsilv2

Board Regular
Joined
Jul 8, 2014
Messages
54
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.
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Matador56

New Member
Joined
Apr 27, 2020
Messages
16
Office Version
  1. 365
Platform
  1. Windows
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,114,419
Messages
5,547,821
Members
410,813
Latest member
Vhinzvirgo
Top