DAX Query

Hi maxkhan 

Can you please use this dax:

Actual_Duration = 
IF(
    ISBLANK('Table'[Actual_EndTime]), 
    'Table'[Planned_Duration], 
    DATEDIFF('Table'[Actual_StartTime], 'Table'[Actual_EndTime], MINUTE) / 60
)

• If Actual_EndTime is null, it will show the Planned_Duration.
• If Actual_EndTime has a value, it will calculate the difference between Actual_StartTime and Actual_EndTime in hours.

Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS