topic Re: DAX Query in DAX Commands and Tips

DAX Query

maxkhan — Mon, 13 Jan 2025 00:59:31 GMT

aoinac

Re: DAX Query

Jihwan_Kim — Fri, 10 Jan 2025 04:06:40 GMT

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

Re: DAX Query

maxkhan — Fri, 10 Jan 2025 04:36:28 GMT

This doesn't work

Re: DAX Query

Poojara_D12 — Fri, 10 Jan 2025 05:31:57 GMT

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

Re: DAX Query

maxkhan — Sun, 12 Jan 2025 21:51:58 GMT

Re: DAX Query

Irwan — Sun, 12 Jan 2025 23:02:01 GMT

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.