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.
So the data pulled from our system returns the date raised, date completed and the target date.
Whats the best way either adding a column or via calculation so calculate whether or not the completion date is less than or equal to the target date.
Ticket number | submittedDate | closedDate | targetDate
xxxxx 12/12/2022 13/12/2022 15/12/2022
If closed date is less than or equal to targetdate then targetHit = true else targetHit = false
Solved! Go to Solution.
Create a custom column named targetHit and put following formula there
= [closedDate]<=[targetDate]
Create a custom column named targetHit and put following formula there
= [closedDate]<=[targetDate]
Many thanks!
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.