Getting x Hour x Minutes from 2 Period of date

[Anonymous]

Dear Team

I'm facing a problem,, as my table below.

Appreciate any help with dax

Thanks you

SE

[Anonymous · Accepted solution]

Thanks any respond

Good things is i solved my self .
i created 2 Column

Duration = Query1[LoadUnloadEndDateTime]-Query1[VehicleReportingDateTime]

and

X.Duration = IF(ISBLANK(Query1[DockName]),BLANK(),
    HOUR(Query1[Duration]) & " Hours and " & MINUTE(Query1[Duration]) &" Minutes")

Salam

SE

[v-shex-msft]

HI @Anonymous,

You can use datediff function to calculate these two fields and get the difference of seconds.
Then you can do some math conversion on total difference seconds to transform them to hours and minutes and use corresponding characters to link them.

Duration =
VAR diff =
    DATEDIFF ( [Date1], [Date2], SECOND )
VAR _hour =
    INT ( diff / 3600 )
VAR _minute =
    INT ( MOD ( _hour, 3600 ) / 60 )
RETURN
    _hour & " Hours " & _minute & " Minutes"

Regards,

Xiaoxin Sheng

[Anonymous]

Thanks brother for ur respond .
but given dax only gv me Hours only and igonring the MInutes

[parry2k]

@Anonymous I clearly mentioned that column is added using PQ ( Power Query) not DAX

[Anonymous]

Thanks anyway for ur respond brother

[parry2k]

@Anonymous solution was attached with my reply, download the pbix file and it has everything. 

[Anonymous]

Brother .

its not showing any dax but table with detail only

how can i used that if om not getting any dax

Thanks

[parry2k]

@Anonymous it is easier to do int PQ, see an attached solution. I created a sample table and added a column in PQ called Elapsed Time. You can tweak the solution the way you want.

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Anonymous]

Hi brother

can u help me on dax .
viewed your page, but cant found what i need

Thanks You

SE