For the streaming data find the row count of last 5 minutes vs 5 minutes before that

[Anonymous]

Hi Team,

I am working on power bi report for streaming data, need help to find the row count of last 5 minutes vs 5 minutes before that

Thanks

[v-eqin-msft]

Hi @Anonymous ,

Could you please tell me  if your problem has been solved by @amitchandak 's post? If it is, kindly Accept it as the solution to make the thread closed. More people will benefit from it.

If not , please provide me with more details about your table and your expected output or share me with your pbix file after removing sensitive data.

Best Regards,
Eyelyn Qin

[amitchandak · Accepted solution]

@Anonymous , You can try measure like these

last 5 =countrows(filter(Table, Table[Datetime] > now() - time(0,5,0) && Table[Datetime] <=now()))

last 5 before 5 countrows(filter(Table, Table[Datetime] > now() - time(0,10,0) && Table[Datetime] <=now()-5))

in case there is filter on date time, use all(Table[datetime]) in place of Table in filter