Forum Discussion

JuliaYebra's avatar
JuliaYebra
Helper III
8 years ago
Solved

Last reading

Hello, I have this dataset with different temperature readings for same items. Is it any way to only keep the last reading for each item? This would be the yellow records. Thanks
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Go to Modeling and hit New Table.

     

    NewTable = SUMMARIZE(
	FILTER(
		ADDCOLUMNS(
			TableName,
			"Last Reading", VAR lastreadingdate = CALCULATE(
				MAX(TableName[Date]),
				ALLEXCEPT(TableName, TableName[Item])
			)
			RETURN IF(TableName[Date] = lastreadingdate, TRUE, FALSE) 
		),
		[Last Reading] = TRUE
	),
	TableName[Machine], TableName[Item], TableName[Date], TableName[Temperature]
)
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Essentially that same column is in my solution. I just nested it inside a calculated table, then used it to filter the table so only the max date rows are kept, then removed the calculated column because you don't actually need to see it after that.

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

That was ingenious Anonymous