Forum Discussion
Compare dates and calculate %
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 ...
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
Greg_Deckler
Community Champion
Community ChampionAnonymous - I think you want something like Open Tickets - https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364#M147