Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
@Anonymous , You need to create a new column
if( [Date] = Max(Table[Date]) , [Model] , " Active", [Model])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
76 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |