DAX Query

[maxkhan]

aoinac

[Poojara_D12 · Accepted solution]

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 

[maxkhan]

 

[Irwan]

hello @maxkhan 

you asked a logic for DAX but your display shows Power Query? Power Query uses M not DAX.

What’s the Difference Between DAX and Power Query or M?

@Jihwan_Kim & @Poojara_D12 should have work in calculated column DAX not PQ.

Thank you.

[maxkhan]

This doesn't work

[Jihwan_Kim]

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]
)