Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
@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
@amitchandak Thanks. It worked. I didn't check the field/data type for one of the dates that's what was causing the error.
@Anonymous - I think you want something like Open Tickets - https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364#M147
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |