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.
@Nishanth1996 , You need to create a new column
if( [Date] = Max(Table[Date]) , [Model] , " Active", [Model])
Check out the changes to the Power BI Community announced at Build.
Find out more about the May 2023 update.
Visit our Data Stories Gallery and give kudos to your favorite Data Stories.