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
Anonymous
Not applicable

Replace last value and Return column

Hi Everyone,

Can anyone help me with, How to rename last product value based on max date in column and return all values same.

Ex: One column contains Model1, Model 2, Model 3 with respective dates and currently Model-3 is active, So we need to show in slice "Model-3 Active" and its completely work in dynamic way.

 

Thanks in advance.

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , You need to create a new column

 

if( [Date] = Max(Table[Date]) , [Model] , " Active", [Model])

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.