Forum Discussion

M_SBS_6's avatar
M_SBS_6
Helper V
2 years ago
Solved

Measure to return value latest date

Hi, 

I have a measure 

 

Calculate ( sum ( app[total]), app[status] in { "live"})

 

What I now need is the measure above to incorporate the latest date. The date is app[date]. 

 

Any idea how I do this please? 

Need Help
  • AmiraBedh's avatar
    AmiraBedh
    2 years ago

    Simply try :

    LatestTotalMeasure = 
CALCULATE(
    SUM(app[total]),
    app[status] IN { "live" },
    app[date] = MAX(app[date])
)

2 Replies

  • Kaviraj11's avatar
    Kaviraj11
    Solution Sage
    2 years ago

    Hi,

     

    LatestValue =
    VAR _LatestDate = MAX(Table[Date])
    RETURN CALCULATE(
    SUM(app[total]),
    app[status] IN { "live" },
    App[Date] = _LatestDate
    )

  • AmiraBedh's avatar
    AmiraBedh
    Super User
    2 years ago

    Simply try :

    LatestTotalMeasure = 
CALCULATE(
    SUM(app[total]),
    app[status] IN { "live" },
    app[date] = MAX(app[date])
)