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 @Dave_C
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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!
User | Count |
---|---|
204 | |
68 | |
63 | |
58 | |
56 |
User | Count |
---|---|
251 | |
196 | |
87 | |
72 | |
71 |