![\"\"](\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2026\/01\/image.png\")
<\/a><\/figure>\n\n\n\nIf I now visualize the data and sort it by date, it looks like this:<\/p>\n\n\n\n For example, for ID C003, this would mean that the previous status in the first line should be displayed as invalid.<\/p>\n\n\n\n As a first step, I created a measure that displays the row number for the respective data record:<\/p>\n\n\n\n The line number is sorted in such a way that the last record is assigned a 1. This is necessary for later display. <\/p>\n\n\n\n This metric generates an additional ID in the window for each ID:<\/p>\n\n\n\n So, essentially, this is classic windowing, similar to what you might know from SQL Server with the PARTITION_BY command.<\/p>\n\n\n\n Next, the actual metric is needed. While it doesn’t require the previous measure to determine the status, doing so makes it easier to visualize the actual process and filter the results.<\/p>\n\n\n\n <\/p>\n\n\n\n Using this metric, the previous data record is searched for based on the date, and the status is extracted. This then leads to the following:<\/p>\n\n\n\n Now a filter can be applied to the visual to display only the last record in a table:<\/strong><\/p>\n\n\n\n The initial situation was that the data was being read live from a streaming database. Each record had a current status, and the records could be grouped by product. Now I only want to see the latest record, but also … Continue reading <\/a><\/figure>\n\n\n\nRowNumberPerID = \r\nVAR CurrentDateTime =\r\n SELECTEDVALUE ( data[datetime] )\r\nVAR CurrentID =\r\n SELECTEDVALUE ( data[id] )\r\nRETURN\r\nCALCULATE (\r\n COUNTROWS ( data ),\r\n FILTER (\r\n ALL ( data ), \r\n data[id] = CurrentID\r\n && data[datetime] >= CurrentDateTime\r\n )\r\n)\r\n<\/code><\/pre>\n\n\n\n<\/a><\/figure>\n\n\n\nPrevious Status = \r\nVAR CurrentId =\r\n SELECTEDVALUE ( data[id] )\r\nVAR CurrentDateTime =\r\n SELECTEDVALUE ( data[datetime] )\r\nVAR PrevDateTime =\r\n CALCULATE (\r\n MAX ( data[datetime] ),\r\n FILTER (\r\n ALL ( data ),\r\n data[id] = CurrentId\r\n && data[datetime] < CurrentDateTime\r\n )\r\n )\r\nRETURN\r\nCALCULATE (\r\n MAX ( data[status] ),\r\n FILTER (\r\n ALL ( data ),\r\n data[id] = CurrentId\r\n && data[datetime] = PrevDateTime\r\n )\r\n)\r\n<\/code><\/pre>\n\n\n\n<\/a><\/figure>\n\n\n\n<\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"