Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Calculating time difference...

Hi guys,   I have a dataset with the history of changes to items. Some of those items have been 'tagged' as blocked on certain dates. Whilst I've managed to calculate the total time an item has sp...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Sorry for the delay, here is a link to a file with dummy data. The 'write a blog post' item has been blocked since 27th November but has had updates to it since (but still remains blocked). Thanks 🙂

v-kelly-msft's avatar
v-kelly-msft
Community Support
5 years ago

Hi  Anonymous ，

 

I cant match the data with your expected output,but checking the previous data,with the measure below,it works fine:

Measure = SUMX(VALUES('Table'[WorkItemId]),SUM('Table'[Column 2]))

Would you pls explain more about how to get the result you need  based on your .pbix file?

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!