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]))
)

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
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]))
)

 

NewbieJono's avatar
NewbieJono
Post Partisan
2 years ago

Thank you, what does summarise do?