Last Date

[NewbieJono]

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

[v-nuoc-msft]

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

[Ashish_Mathur]

Hi,

With the setup as proposed by Jihwan, write this measure

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

Hope this helps.

[NewbieJono]

this works but its not allowing me to use the same period last year function with it

[Jihwan_Kim · Accepted solution]

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]

Thank you, what does summarise do?