Forum Discussion

NewbieJono's avatar
NewbieJono
Post Partisan
2 years ago
Solved

Last Date

My date table is set to go up to today ()   one of my data table has data up to 01/03/2024.   i want to bring back the latest score from the data table. when I use last day with the date table it...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    2 years ago

    Hi,

    I am not sure how your semantic model looks like, but please try something like below whether it suits your requirement.

     

     

     

     

    Latest - CSLatest = 
CALCULATE (
    [Score - CS],
    LASTDATE(SUMMARIZE(Data, 'Calendar'[Date]))
)

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

With the setup as proposed by Jihwan, write this measure

Measure = calculate([Score - CS],lastnonblank(Calendar[date],calculate([Score - CS])))

Hope this helps.