Forum Discussion
Stream Analytics - Update row in dataset
Hi Cyril,
If they are duplicates, they all could be the most recent. Maybe you can filter them in the beginning. Which visual did you use in the Power BI? Maybe we can filter them using a slicer. About filtering push dataset, please refer to service-real-time-streaming#can-i-use-filters-on-push-dataset-how-about-streaming-dataset.
Best Regards,
Dale
Hi Dale,
Main visual in Power BI are counting rows (distcint), list, bargraph with date, circular, etc..
I don"t know how to get the most recent row between 2.
Thanks
Cyril
- v-jiascu-msft8 years agoMicrosoft Employee
Hi Cyril,
How can we identify the "2"? By date?
Do you mean this scenario below?
row1 news1 date1
row2 news1 date1
row3 news2 date2
Since the row1 and row2 are the same, you need to show up the row1 and row3.
Best Regards,
Dale
- cdupland8 years agoFrequent Visitor
Hi Dale,
My scenario is below :
row1 news1 date1
row2 news1 date2
row3 news2 date1
Row1 and row2 are the same, with date2 > date1.
So, I would like to show row2 and row3.
Thanks
Best Regards
Cyril