Streaming dataset query

[srawatd]

Hi All, 

below is my streaming dataset. 

TimeStamp	Status	Product	Cost	Business
T1	S1	P1	10	B1
T2	S2	P1	20	B1
T3	S1	P1	100	B1
T1	S1	P2	52	B1
T2	S2	P2	41	B1

I want to achieve below result. latest timestamp group by product only. I use max/last function but it is aggregating on all the columns eg, cost,status etc. This is streaming dataset so I can create only calculated measures. not calculated table.

TimeStamp	Status	Product	Cost	Business
T1	S1	P1	10	B1
T1	S1	P2	52	B1

[v-zhangti]

Hi, @srawatd 

You can try the following methods.

Measure = 
IF(SELECTEDVALUE('Table'[TimeStamp])="T1",1,BLANK())

 Put measure into filter and set it equal to 1.

Is this the result you were expecting?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.