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

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

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,118,342
Messages
5,571,657
Members
412,412
Latest member
NWPhotoExplorer
Top