Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Average time per status

Need a bit of help.. most likely something super-easy, but I just can't wrap my head around how to do this...   As you can see from below I have a database that logs every time one of our projects ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Well... still don't get it to work... most likely just me that is overthinking it.

The data that I supplied earlier is as clean as it gets, but it is impossible for me to post all 2,8 million rows of data.

 

I have uploaded the file to my GoogleDrive, and you are welcome to download the pfix file and take a look: statuslog.pbix 

 

Below is a screenshot of the rawdata.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Check. There was an error in the column name

 

last status = maxx(filter('statusLogs','statusLogs'[projectID]=EARLIER('statusLogs'[projectID]) && 'statusLogs'[status]<EARLIER('statusLogs'[status])),'statusLogs'[status])

Hour diff = datediff(maxx(FILTER('statusLogs','statusLogs'[projectID]=EARLIER('statusLogs'[projectID]) && ('statusLogs'[status])=EARLIER('statusLogs'[last status])),'statusLogs'[statusTime]),'statusLogs'[statusTime],HOUR)