Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Running total till date

Hi,

I want help with the running total till date iam getting the total throughout the whole year i have tried every possible solution but has nothing worked.If i get help it would be really appreciated.

FY ends 06/30, FYmon is FY month no.

Actual_MM1 = CALCULATE(CALCULATE(COUNT(FTE[ACTUALDATE]), FTE[activitycodedescription]="Mass Mailing 1"))
YTD= CALCULATE(COUNT(FTE[ACTUALDATE]),FTE[activitycodedescription]="Mass Mailing 1" ,FILTER(ALLSELECTED(FTE),FTE[FYmon]<=MAX(FTE[FYmon]) )when i select current fiscal year the total should stop till september but it goes till end of the year .
Need Help
Show and Tell
  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    Anonymous ,

     

    Modify your measure using dax below and check if it can meet your requirement:

    YTD =
CALCULATE (
    COUNT ( FTE[ACTUALDATE] ),
    FILTER (
        ALLSELECTED ( FTE ),
        FTE[activitycodedescription] = "Mass Mailing 1"
            && FTE[FYmon] <= MAX ( FTE[FYmon] )
    )
)

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Anonymous ,

     

    Modify your measure using dax below and check if it can meet your requirement:

    YTD =
CALCULATE (
    COUNT ( FTE[ACTUALDATE] ),
    FILTER (
        ALLSELECTED ( FTE ),
        FTE[activitycodedescription] = "Mass Mailing 1"
            && FTE[FYmon] <= MAX ( FTE[FYmon] )
    )
)

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.