Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Correct Data in Power Query but different values in Table View

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

Need Help

1 Reply

  • HotChilli's avatar
    HotChilli
    Community Champion
    2 years ago

    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