Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Broly221
Frequent Visitor

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 we should put "AAA" in the entire column.

Broly221_0-1677018420341.png

How can in please achieve that ?

thanks 

1 ACCEPTED SOLUTION
olgad
Super User
Super User

Hi,
measure, not column

Latest Barnd Value = Calculate(
    Calculate(max(Table[Brand]), Filter(Table, Table[CreationDate]=Max(Table[CreationDate])))
,All(Table))

DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime

View solution in original post

4 REPLIES 4
Broly221
Frequent Visitor

thanks for your help !

Len_Barr
Resolver I
Resolver I

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

thank you !

olgad
Super User
Super User

Hi,
measure, not column

Latest Barnd Value = Calculate(
    Calculate(max(Table[Brand]), Filter(Table, Table[CreationDate]=Max(Table[CreationDate])))
,All(Table))

DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.