Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
maxkhan
Frequent Visitor

DAX Query

aoinac

1 ACCEPTED SOLUTION
Poojara_D12
Super User
Super User

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 

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 - Proud to be a Super User
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS

View solution in original post

5 REPLIES 5
Poojara_D12
Super User
Super User

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 

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 - Proud to be a Super User
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS

Screenshot 2025-01-13 082131.png

hello @maxkhan 

 

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

Irwan_0-1736722863322.png

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
Frequent Visitor

This doesn't work

 

Jihwan_Kim
Super User
Super User

Hi,

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

 

Jihwan_Kim_0-1736481975617.png

 

 

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

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Visit my LinkedIn page by clicking here.


Schedule a meeting with me to discuss further by clicking here.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.