Forum Discussion

Junaid11's avatar
Junaid11
Helper V
4 years ago

Progress based on two dates

Hello, I have a table for course start date and course completion. I want to get progress in % to see how much progress have been made. Like if it started in January and was to complete in December ...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

Junaid11 , Try a measure like

 

measure =
var _max = maxx(allselected('Date'), 'Date'[Date])
return
divide(Sumx(Table,datediff(Table[Start Date],_max, Day)+1) ,Sumx(Table,datediff(Table[Completion Date],_max, Day)+1) )