Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
)
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
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
)
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.
This doesn't work
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]
)
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.
User | Count |
---|---|
21 | |
20 | |
15 | |
10 | |
7 |
User | Count |
---|---|
29 | |
28 | |
12 | |
12 | |
12 |