Forum Discussion
Solved
Get the most recent value from a numeric column
Hello, I have a table with lower and upper limits given for specific products (mix name) and measurements method (propertie). Those limits can change with time, and I'm looking for a DAX measurement ...
Hi all! I found a great solution on this last post: https://community.powerbi.com/t5/Desktop/How-can-I-get-the-last-value-of-a-column-in-my-dataset/td-p/33602
I put the solution in an updated picture, thanks to all answers below!
see you,
camargos88
Community Champion
Community ChampionHi GAETAN63 ,
Create this new column:
LastItem = IF('Table'[Date] = CALCULATE(MAX('Table'[Date]); filter('Table'; 'Table'[Name] = EARLIER('Table'[Name]))); 1; 0)
Filter the visual: