Welcome, Guest
Username Password: Remember me
Please ask here your questions related to DAX and PowerPivot for Excel or PowerPivot for SharePoint. To post your question or reply you need to login first!
  • Page:
  • 1

TOPIC: Sum value + Minutes & Hours

Sum value + Minutes & Hours 3 years, 5 months ago #280

  • mikej55
  • OFFLINE
  • Fresh Boarder
  • Posts: 1
  • Karma: 0
Hi

I have a power pivot running off a sql server database table. The table stores timesheet records for all employees. The employee times are split into two columns, minutes and hours both of type int. In the power pivto window, I have created a new column (CalMinutes) and used DAX to convert the hours to minutes and add with the specific minutes entered.

In my pivot table, I've added the column CalMinutes to the Values field and set the "Summarize by" to Sum. So now for some of the users, I have a value of 29,550 minutes. How can I go about coverting this value to hours and minutes. I tried to add a measured value, but that results in the table loading all projects for everybody and setting the measured value to blank.

Regards

Michael.
  • Page:
  • 1
Moderators: VidasMatelis, dgosbell
Time to create page: 0.13 seconds
 

Pyramid+PowerPivot