Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Last Value

Hello,

 

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

Thanks

 

 

Need Help
  • TomMartens's avatar
    TomMartens
    8 years ago

    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

3 Replies

  • vega's avatar
    vega
    Resolver III
    8 years ago

    Please try this:

     

     

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

     

  • TomMartens's avatar
    TomMartens
    Super User
    8 years ago

    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

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    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.