Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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 dateTarget Date
115/08/202020/08/2020
217/08/202015/08/2020
320/08/202020/08/2020
423/08/202020/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")
 SLA.jpg

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@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
Not applicable

 @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
Super User
Super User

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


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.