Forum Discussion
Time delta for a calculated column, when sorted by time
I wondered if this was a limitation powerBI imposes on live streamed data over historic data, the former of which is only available in the latter after 24 hours.
However, trying that it seems to make no difference to the output. Frustratingly poiwerBI seems to have sacrificed functionbality for accesibility. It is a lot prettier than messing around with the database and scripts directly, but has far more limitations on what ca neasily be achievd - or at least that seems to be the case so far!
Community SupportHi Anonymous ,
Try the following formula:
Measure =
IF(
MAX(events[times tamp]) = MINX(ALL(events),events[times tamp]),
BLANK(),
FORMAT(
MAX(events[times tamp]) - MAXX(
FILTER(
ALL(events),
events[times tamp] < MAX(events[times tamp])
),
events[times tamp]
),
"0.00000"
)
)
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- v-kkf-msft
Hi Anonymous ,
Did I answer your question? If you can get the correct result, please accept as solution so that users with the same problem can find it quickly.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
WinnizIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.