Forum Discussion

joshua1990's avatar
joshua1990
Icon for Post Prodigy rankPost Prodigy
5 years ago

Fiscal Month Running Total

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. 

DateSalesRunning Total
02.08.2021150000150000
03.08.20210150000
04.08.20210150000

 

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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Try using ALLSELECTED instead of ALL.