how to get list of last readings of a particular item

[PowerrrBrrr]

I have a list of machines as below with timestamp and Value columns. Timestamps and Value are in different table and Machines are in different table. Both are connected by one-many relationship.

If a machine has a Value 0 then it is said to be inactive. I would like to show a visual in my Power Bi, which tells me when the Pump was last inactive i.e. when the value was 0 for pumps.

So I have input table :

ID	Machines
1	Machine1
2	Machine2
3	Machine3
4	Machine4
5	Machine5
6	Machine6
7	Machine7

Table 2:

ID	Value	Timestamp
1	0	2021-12-12
1	54	2021-11-21
2	22	2021-11-20
3	43	2021-10-01
2	2	2021-10-12
4	11	2021-12-12
4	0	2021-12-12
5	0	2021-11-12

Visual I would like to see in my Power Bi

Machine	Inactive Date
1	2021-12-12
4	2021-12-12
5	2021-11-12

[amitchandak · Accepted solution]

@PowerrrBrrr , Hope the two tables are connected Id. Take machine from the first table and this measure from the second table

maxx(filter(Table2, Table2[Value] =0), Table2[Date])