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,
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.
How can in please achieve that ?
thanks
Solved! Go to Solution.
Hi,
measure, not column
thanks for your help !
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 !
Hi,
measure, not column
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |