Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |