Forum Discussion

Broly221's avatar
Broly221
Frequent Visitor
3 years ago
Solved

Copy latest row value in entire column

Hi,   I have a table with a date column. I want to create a new column that will look at the latest "Brand" value and put it in the entire column. in this case : latest value is 1 feb 23 therefore ...
Need Help
Show and Tell
Tutorial Requests
  • olgad's avatar
    olgad
    3 years ago

    Hi,
    measure, not column

    Latest Barnd Value = Calculate(
        Calculate(max(Table[Brand]), Filter(Table, Table[CreationDate]=Max(Table[CreationDate])))
    ,All(Table))
Anonymous's avatar
Anonymous
Not applicable
3 years ago

As Olga said, use a measure, not a column

 

I'd do it differently though. 

 

FIRST OF ALL, disable auto time detection - otherwise the last date is going to be way later than your actual date. 

File - options and settings - options - current file - data load - time intelligence - unclick "Auto date/time for new.."

 

Then use this in a MEASURE. You may have to change the table/column names to fit your data. 

Lookuplast =

VAR Last = MAX('Table'[Datecolumn])

RETURN

LOOKUPVALUE('Table'[Brand], 'Table'[Datecolumn], [Last])

Broly221's avatar
Broly221
Frequent Visitor
3 years ago

thank you !