Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hey All
I am trying to find if someone has breached a SLA with customer action.
I have a due date and time column and a completed date and time column
Due Date | Completed Date |
02/06/2020 17:00:00 | 02/06/2020 16:45:00 |
02/06/2020 17:00:00 | 02/06/2020 17:45:00 |
I want it to be conditional to find which rows have have a > Completed Date than Due Date.
It would also be good to be able to count and filter this.
I can get it working for the date alone but not a date/time field.
Would a new column be better?
Any help would be appreciated.
Thanks, Daniel.
Solved! Go to Solution.
HI @Dan492813 ,
You can do this is Power Query too
Make sure your Data Type is Date/Time.
Create a Custom Column.
You can also create a Custom Column
Column = if ('Table'[Due Date] < 'Table'[Completed Date] , "true","false")
Regards,
Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
@Dan492813 , Not sure I am clear
You can use this both measure or column
Table[Completed Date].date >Table[Due Date].date
measure = calculate(countrows(Table), filter(Table,Table[Completed Date].date >Table[Due Date].date))
Sorry I wasn't clear..
IF Due Date is < Completed date then 'true' else 'false'. It wont take into account the time only the date
HI @Dan492813 ,
You can do this is Power Query too
Make sure your Data Type is Date/Time.
Create a Custom Column.
You can also create a Custom Column
Column = if ('Table'[Due Date] < 'Table'[Completed Date] , "true","false")
Regards,
Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |