Progress based on two dates

[Junaid11]

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 then on selection from slicer for june it should show how much was the progress based on the dates. It should be able to slice monthly except the last month, quarterly, yearly etc.There are different courses so the progress should be accumulative like total of progress based on dates. Hope you undestand.

I am attaching the data below.

Thank you

Course	Assignment Date	Completion Date	Completion Status
ABC	23/03/2020	23/07/2021	Complete
LFC	08/04/2021	25/11/2022	Complete
NML	24/04/2022	29/03/2024	Incomplete
PQL	10/05/2021	01/08/2025	Incomplete

[v-jingzhang]

Hi @Junaid11 

I don't quite understand the expected result. What do you mean by "the progress should be accumulative"? Do you want to have a progress value for every course?

And when you want to slice it monthly, quarterly or yearly, we need to specify a date to represent the month/quarter/year. You want to use the first date or the last date or other dates in that period? When selecting different dates to calculate the progress %, the results would be different. Can you give an example that which result is you expect?

Best Regards,
Community Support Team _ Jing

[amitchandak]

@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) )