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.
I am calculating the amount of time to close a case during business hours which is a dynamic number based on the group. I am using a similar function to do so while only changing the open date and closed date for the two equations but receive an error message with the second equation.
Solved! Go to Solution.
Your second formula breaks probably because of null or blank values in the ClosedDate field. You may want to add a check using IF condition in your formula if that is the case.
e.g.
LastDayEndTime = IF(ISBLANK('Table'[Date]), BLANK(), 'Table'[Date] + 'Table'[Time])
Regards,
Tarun
Did I answer your question? Mark my post as a solution!
Your second formula breaks probably because of null or blank values in the ClosedDate field. You may want to add a check using IF condition in your formula if that is the case.
e.g.
LastDayEndTime = IF(ISBLANK('Table'[Date]), BLANK(), 'Table'[Date] + 'Table'[Time])
Regards,
Tarun
Did I answer your question? Mark my post as a solution!
That did the trick, thank you Tarun
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |