Forum Discussion

deepblue_m45's avatar
deepblue_m45
Frequent Visitor
4 years ago
Solved

Calculate Sum for Max Date -1

I have a variety of visuals showing trends over various periods and want to create a measure to place in a card visual that will calculate the max date in the visual which I have, below (h/t to AlB f...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi deepblue_m45 

Please try

Max Date =
VAR __latestdate =
    MAXX (
        ALLSELECTED ( 'Date Hierarchy'[Month Year] ),
        'Date Hierarchy'[Month Year]
    )
RETURN
    CALCULATE (
        SUM ( 'DataTable-2020-2022'[Value] ),
        FILTER ( 'Date Hierarchy', 'Date Hierarchy'[Month Year] = __latestdate )
    )
deepblue_m45's avatar
deepblue_m45
Frequent Visitor
4 years ago

Thanks for the reply! I plugged this in and it works great for the May date. Is there a way to use this to show the month before that (the April equivalent)?