Forum Discussion

Birdjo's avatar
Birdjo
Icon for Resolver II rankResolver II
9 years ago

Filter Report by Max Date

Hello, I am working on a human resources report where I have to use the different positions. But when our employees edit the positions new row appears, while I only need the latest version of the ...
Need Help
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Birdjo

Here is a measure that might work

 

Last Worker = CALCULATE
				(MAX('Table3'[WORKER]),
				FILTER(
					'Table3',
					[MODIFIEDDATETIME]=MAX('Table3'[MODIFIEDDATETIME])
					)
				)

Or this will give you a 1 line table that you can build on

New Table = 
VAR 
    LastModifiedDate = MAX('Table3'[MODIFIEDDATETIME])
RETURN 
    FILTER(
        'Table3',
        'Table3'[MODIFIEDDATETIME]=LastModifiedDate
        )