Forum Discussion
Getting Distinct data by Latest Date
Hi, I have the below data, my requirement is like getting the latest data by date and should get distinct records. The excel file will be updated daily 3-4 times and so the data will be duplicate...
Sudharshan1919 , use measure for all columns other than region and DateTime, for DateTime tale max
Measure =
VAR __id = MAX ('Table'[Region] )
VAR __date = CALCULATE ( MAX('Table'[Datetimefetched] ), ALLSELECTED ('Table' ), 'Table'[Region] = __id )
return
CALCULATE ( max ('Table'[servername] ), VALUES ('Table'[Region] ),'Table'[Region] = __id,'Table'[Datetimefetched] = __date )