Last Value

[Anonymous]

Hello,

Need to create a calculated column with the last date (dd/mm/yy hh:mm:ss). Is someone able to help?

Thanks

 

[Ashish_Mathur]

Hi,

Try this.  I cannot read the title in cell F1.  Assuming it is 4 Marcacao. try this

=CALCULATE(MAX(Data[4 Marcacao]),FILTER(Data,Data[4 Marcacao]<EARLIER(Data[4 Marcacao])))

Hope this helps.

[TomMartens · Accepted solution]

Hey, assuming your table looks like this

and you want to create a Calculated Column "PreviousDateTime" (Calculated Column means your are looking for DAX solution)
then this DAX statement finds the previous DATETTIME value in column "aDateTimeColumn":

PreviousDateTime = 
var currentDateTime = 'FindPreviousDateTime'[aDateTimeColumn]
return
CALCULATE(
    MAXX(
        ALL('FindPreviousDateTime'[aDateTimeColumn])
        ,IF('FindPreviousDateTime'[aDateTimeColumn] < currentDateTime, 'FindPreviousDateTime'[aDateTimeColumn], BLANK())
    )
)

Maybe you will think this code is a little to much, but beeing in a ROW Context of a table (we want to create a CALCULATED COLUMN), this helps to avoid the awkward message "... circular dependency ..." 🙂

Hope this helps

Tom

[vega]

Please try this:

LastValue = 
VAR curDate = 'Table'[4#MARCACAO]
RETURN
CALCULATE(
    MAX('Table'[4#MARCACAO]),
    ALL('Table'),
    FILTER('Table', 'Table'[4#MARCACAO] < curDate)
)