Compare dates and calculate %

[Anonymous]

Hi, 

I need to compare two dates (completion date & target date) and calculate a % of items that were completed within the set target date. 

My data looks like below : 

Item #	Completion date	Target Date
1	15/08/2020	20/08/2020
2	17/08/2020	15/08/2020
3	20/08/2020	20/08/2020
4	23/08/2020	20/08/2020

The data type for both the date columns is set to date. 

If the completion date is less than or equal to the target date, then display Met else Not met. Then calculate a % of the total items that met the SLA. 

To compare the two dates and return a value in a calculated column, I am using the 'IF' function, however, I get the following error

SLA = If(TestWorkFlow[ActualCompletionDate]< TestWorkFlow[TargetDate],"Met", "Not met")

 

[amitchandak · Accepted solution]

@Anonymous , check data type of both columns it should be date and datetime

Also this should be column

SLA = If(TestWorkFlow[ActualCompletionDate]< TestWorkFlow[TargetDate],"Met", "Not met")

Also check for date form dd/mm/yyyy

https://community.powerbi.com/t5/Desktop/How-to-apply-UK-date-format-dd-mm-yyyy-in-Date-slicer/td-p/599712

[Anonymous]

 @amitchandak  Thanks. It worked. I didn't check the field/data type for one of the dates that's what was causing the error.

[Greg_Deckler]

@Anonymous - I think you want something like Open Tickets - https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364#M147