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

CourseAssignment DateCompletion DateCompletion Status
ABC23/03/202023/07/2021Complete
LFC08/04/202125/11/2022Complete
NML24/04/202229/03/2024Incomplete
PQL10/05/202101/08/2025Incomplete
Need Help

2 Replies

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

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    4 years ago

    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