Show percentage of Completion Date vs Target Date

[pvravestein]

Hi 

I am looking for a solution to something I have to little experience with.

I have 2 columns as below with example dates:

Completion date	Target Date
14/11/2022 08:27:00	14/11/2022 14:42:00
25/11/2022 09:46:00	14/11/2022 16:00:00
14/11/2022 16:00:00	14/11/2022 16:15:00
14/11/2022 13:23:00	15/11/2022 08:00:00

I need to now which percentage of the completion date is below the target date. This is positive.

So in this case it should be 75% because 3 are within target date.

How can I do this?

Thanks

[Bifinity_75 · Accepted solution]

Hi @pvravestein , ya can create this measure: (Name of your table is "Table1"):

Percentage = var a_=CALCULATE(COUNT(Table1[Completion date]),
                Table1[Completion date]<Table1[Target Date])
            return
            DIVIDE(a_,COUNTROWS(Table1),"-")

- The result:

Best regards

[pvravestein]

Thanks, it seems to work. Still have some tweaking to do but this was very very helpfull.