Forum Discussion

srawatd's avatar
srawatd
Frequent Visitor
4 years ago

Streaming dataset query

Hi All, 

below is my streaming dataset. 

TimeStampStatusProductCostBusiness
T1S1P110B1
T2S2P120B1
T3S1P1100B1
T1S1P252B1
T2S2P241B1
     

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.

TimeStampStatusProductCostBusiness
T1S1P110B1
T1S1P252B1

 

Need Help

1 Reply

  • v-zhangti's avatar
    v-zhangti
    Community Support
    4 years ago

    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.