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

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi NewbieJono

 

Ashish_Mathur Jihwan_Kim Thank you very much for your prompt reply.

 

NewbieJono Can you tell me if your problem is solved? If yes, please accept it as solution.

 

If you're still having problems, provide some dummy data and the desired outcome. It is best presented in the form of a table.

 

Regards,

Nono Chen