Forum Discussion
DAX Query
aoinac
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
5 Replies
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] )This doesn't work
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 
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.
