Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 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 apprecia...
Need Help
Show and Tell
  • v-yuta-msft's avatar
    v-yuta-msft
    7 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.

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
7 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.