return date of lastnonblank - Last Updated Google Sheet - is this measure optimal?

[Peta_g]

Hey brains trust

I'm connecting to a Google Sheet that has number of columns input by staff most days. The Date field is prepopulated.

I want a measure that tells me the last date that a column [Amount Spent] had a value.

Is this the best way to achieve - (it is working but I'm new at this so not sure if this is the best way?):

Last Updated = CALCULATE(

MIN(WebDailyAdStats[Date]),

WebDailyAdStats[Amount Spent] = BLANK()

Cheers

[wdx223_Daniel]

@Peta_g this code might get the last date

Last Updated = LASTNOBLANK(ALL(WebDailyAdStats[Date]),CALCULATE(SUM(WebDailyAdStats[Amount Spent]),ALL(WebDailyAdStats)))

[amitchandak]

@Peta_g , that is correct, But use like

Last Updated = CALCULATE(
MIN(WebDailyAdStats[Date]),
isblank(WebDailyAdStats[Amount Spent]))