Correct Data in Power Query but different values in Table View

[Anonymous]

Hi, I am not seeting the same data on power query and table view. The column is data type: Duration

Power Query 

Table view

Why are they different? The values shown in the power query are the correct values. I didnt change anything except transform the column to duration in the power query. The data type in the table view is below.

How do I make it show the values shown in the power query?

Thanks

[HotChilli]

You'll find lots of posts on this subject.  There is no duration type in DAX, so you get a decimal (which is a fraction of day - maybe, can't remember off the top of my head).  You might want to change in power query to minutes and pass that through as a whole number.  You'll find various DAX code on the forum to present that as hrs, mins if required