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.
I have a table that tracks different status's. I have created date and times, for each event. I need to know how to get the amount of time between events.
Hi @Anonymous
You may create measures like below.
Last_event_date = CALCULATE(MAX('Table1'[Date]),FILTER(ALL('Table1'),'Table1'[Index]=MAX('Table1'[Index])-1))
Measure = DATEDIFF([Last_event_date],MAX(Table1[Date]),HOUR)
Regards,
This is the query that the my coder has built to get data into his world, but we need to get this up to the Power BI system to use.
This needs to be in a direct query model if at all posible
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |