Forum Discussion
Solved
DAX or Add of Column
Good Day, I need some help with the below example. The bold colour is the raw data extracted from my system. Keep in mind that the data comes from two data sets where it is match so the created d...
coetseem , Try a new column like
if([Creation date] = maxx(filter(Table, [ID] = earlier([ID]) ), [creation Date]) , [Quote Value] , Blank())
for measure try like
Latest
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0
amitchandak
Super User
Super Usercoetseem , Try a new column like
if([Creation date] = maxx(filter(Table, [ID] = earlier([ID]) ), [creation Date]) , [Quote Value] , Blank())
for measure try like
Latest
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0