Forum Discussion

maxkhan's avatar
maxkhan
Frequent Visitor
1 year ago
Solved

DAX Query

aoinac
  • Poojara_D12's avatar
    Poojara_D12
    1 year ago

    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 

Jihwan_Kim's avatar
Jihwan_Kim
Super User
1 year ago

Hi,

I tried to create a sample pbix file like below, and please check the below picture and the attached pbix file.

 

 

 

DATEDIFF function (DAX) - DAX | Microsoft Learn

 

Expected result CC =
IF (
    NOT ISBLANK ( data[actual_end_time] ),
    DATEDIFF ( data[actual_start_time], data[actual_end_time], HOUR ),
    data[planned duration]
)