Fiscal Month Running Total

joshua1990 — Tue, 03 Aug 2021 08:57:41 GMT

I would like to get the running total for the selected fiscal month on a daily level.

This is the measure I have built so far:

Running Total = VAR RunningTotal = CALCULATE ( [Sales], FILTER ( ALL ( 'Fiscal Calendar' ), 'Fiscal Calendar'[Fiscal Year] = VALUES ( 'Fiscal Calendar'[Fiscal Year] ) && 'Fiscal Calendar'[Fiscal Month Num] = VALUES ( 'Fiscal Calendar'[Fiscal Month Num] ) && 'Fiscal Calendar'[Date] <= TODAY() ) ) RETURN RunningTotal

Unfortunately, this measures shows me in a matrix with dates as rows the running total for every day.

Date	Sales	Running Total
02.08.2021	150000	150000
03.08.2021	0	150000
04.08.2021	0	150000

Why is that so? I have a filter on "TODAY". What have I missed?

Re: Fiscal Month Running Total

Anonymous — Tue, 03 Aug 2021 14:59:43 GMT

Try using ALLSELECTED instead of ALL.

Re: Fiscal Month Running Total

joshua1990 — Wed, 04 Aug 2021 11:09:48 GMT

Nope, that makes no changes

topic Re: Fiscal Month Running Total in DAX Commands and Tips

Fiscal Month Running Total

Re: Fiscal Month Running Total

Re: Fiscal Month Running Total