DAX Help: Running YTD Total by Day

Looking for help on this Dax Measure I wrote. Below is the Measure that Needs Adjusting Note - Company Fiscal Year is May - April PY Net Sales = SWITCH([Selected Period], "MTD", CALCULATE(SUM(S...

Need Help

Anonymous

2 years ago

Hi,

Thanks for the solution Greg_Deckler and 123abc offered and i want to offer some more information for user to refer to.

hello IamTDR , you can create the following measure

MEASURE =
VAR a =
    CALCULATE (
        MIN ( Dim_Date[Date] ),
        ALL ( Dim_Date ),
        Dim_Date[Fiscal Year] = 2024
    )
RETURN
    IF (
        SUM ( 'Table'[sales_net] ) <> BLANK ()
            && MAX ( Dim_Date[Fiscal Year] ) = 2024,
        CALCULATE (
            SUM ( 'Table'[sales_net] ),
            FILTER ( Dim_Date, [Date] >= a && Dim_Date[Date] <= EDATE ( TODAY (), -12 ) )
        )
    )

Ouptut