Forum Discussion
Time delta for a calculated column, when sorted by time
I have a set of data, each with a timestamp. I am trying to create a calculated column that, for each row, contains the time delta between that row and it's chronological predecessor, when the d...
amitchandak
Super User
Super UserAnonymous , Create a new column like
[timestamp] - maxx(filter(Table, [timestamp] < earlier([timestamp])),[timestamp])
Thanks - almlost:
My time collumn is called "timestamp" - and contains time data - but I'm getting the error shown in the image above...
Ok...it looks like I can't create that in a "measure" - it has to be in a new column. But since I am consuming a remote data source, I can't create a new column. I think this means that this is just a limitation of powerBI - unless I am missing something...
It seems that powerBI is potentially a good agregator of myriad data sources, but analysis of those feeds theselves it is a better done at source?