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.
Hey!!
How're you doing?
I'm creating a BI to analise some stuff, but i'm having some issues manipulating time values.
The data was gettered from mongoDB in a connection with R and, with that all the data came in one, i mean, all de status and its updates came with it's respective time, so i can't calculate between columns for, as all the datatimes lies on the same column, and the power bi won't let me use simple "Datediff" ou calculate just with the column, when it asks for a previews operation like max('status'[datetime]), what i think would just give me the last data.
My objective is to adquire the time beetween a change of status for each id on the table, or at least it's maximum and it's mean values.
Here's a exemple of what i'm talking about:
Id | Status | Datetime |
5ff34563ebaa650023799723 | ENTER_QUEUE | 04-01-2021 16:42:11 |
5ff34566ebaa650023799725 | IN_ATTEND | 04-01-2021 16:42:14 |
5ff3457bebaa65002379972a | FINISH_ATTEND | 04-01-2021 16:42:36 |
5ff3456eebaa650023799727 | ENTER_QUEUE | 04-01-2021 16:42:23 |
I've tried to do many thing with that but it's getting weird to do, like i did a table for each status and then merged it's times to compare, and it's the closest I got to what I need.
Sorry if it's too basic or not a proper topic to discuss, but i'm kind of new on power bi.
@Anonymous See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/339586.
The basic pattern is:
Column =
VAR __Current = [Value]
VAR __PreviousDate = MAXX(FILTER('Table','Table'[Date] < EARLIER('Table'[Date])),[Date])
VAR __Previous = MAXX(FILTER('Table',[Date]=__PreviousDate),[Value])
RETURN
__Current - __Previous
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 |
---|---|
41 | |
19 | |
19 | |
16 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |