Forum Discussion
Solved
DAX - Need Help
Hi, I need some guidance on this new calculated column. I have this example of data. You can see I have 2 reapeted items, which have two different states, I need to calculate how much time pa...
MCALDERON , Try a new column like
var closeCase = minx(filter('Brazil Compliance Modernization', [work_item_id] =earlier([work_item_id]) && 'Brazil Compliance Modernization'[State]= "Closed") 'Brazil Compliance Modernization'[Date])
var doneCase = maxx(filter('Brazil Compliance Modernization', [work_item_id] =earlier([work_item_id]) && 'Brazil Compliance Modernization'[State] = "Done"), 'Brazil Compliance Modernization'[Date])
return
if( [status]= "Done", DATEDIFF(closeCase,doneCase,DAY) , blank())
Awesome, that helps, thanks a lot!!