Forum Discussion
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 que...
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