Power Pivot (Smart Tag ! Range Error) - H:MM:SS not functioning in Values

[zgoldflo]

I created a Power Pivot table (I checked the 'add this to the Data Model' box). I have this Smart Tag (Yellow Diamond !) error showing up next to my Range.

My source Data is currently in a Table format. The only function I tried to do which may have triggered this error might have been a DAX function in which I was trying to insert a =Median formula for one of my columns (DAX function since deleted). Or when I had dragged a column named ride_length (data formatted as h:mm:ss) into the values section

The main issue (which I have encountered before) is that when dragging the ride_length column into the Values section and formatting it to h:mm:ss and then trying to get the Average - the Average option is grayed and not allowing it as an option. I have another Pivot Table in the same workbook (different sheet) connected to the same data source (before the Data Source was formatted into a Table) and I was able to fix this issue. But for some reason once I changed my data source into a Table format I have been having issues.

I duplicated the issue a number of times. It seems to be that when I select 'add this to the Data Model' box the Pivot Table cannot compute the h:mm:ss as an Average? Any help would be appreciated!

Also, I can't take any Mini Sheet shots of the excel file it keeps on crashing....

 

[Alex Blakenburg]

I expect that the simplest way is to select the ride duration column in the data model and make it the decimal data type
You can then perform whatever operation you want in the pivot table and apply the number format > time > hh:mm:ss in the pivot