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 returns a blank

Latest - CSLatest = 
CALCULATE (
    [Score - CS,
    LASTDATE ( 'DIM - Date Table'[Date] )
)

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.pbix20 KB
- NewbieJono
  Post Partisan
  2 years ago
  Thank you, what does summarise do?
NewbieJono
Post Partisan
2 years ago
this works but its not allowing me to use the same period last year function with it
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.
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

Forum Discussion