Power Pivot - Sum Issue

[d0hb0y]

I am using the Data Model to combine three (3) different tables utilizing an Employee ID column for the link.

When I use this mode to create a Pivot Chart, I receive the below message.



The three tables created are Train_Tble, RollCall_Tble, and Sim_Tble. When attempting to just grab a Sum of the Hours, I receive the message above. However, I can get a sum just by summarizing as a pivot table. The Hours column is formatted as Time in the Table and Data Model.




The formulas in the table are:

Day: =IF([@Date]="","",TEXT([@Date],"DDDD"))
FQtr: =IF([@FMnth]="","",INDEX(FQtrTble,MATCH([@FMnth],FQtrTble[FMnth],0),2))
FMnth: =IF([@FWk]="","",INDEX(FiscalTble,MATCH([@FWk],FiscalTble[Fwk],0),2))
FY: =IF([@Date]="","",YEAR(EOMONTH([@Date],AddMths)))
FYStart: =IF([@Date]="","",DATE([@FY]-1,FYNum,2))
FWkStart: =IF([@FYStart]="","",[@FYStart]-WEEKDAY([@FYStart],1)+1)
FWk: =IF([@Date]="","",INT(([@Date]-[@FWkStart])/7)+1)
Attendees: =XLOOKUP([@[Employee ID]],Employee_Tbl[Employee ID],Employee_Tbl[Officer],"")
Shift: =XLOOKUP([@[Employee ID]],Employee_Tbl[Employee ID],Employee_Tbl[Shift],"")

 

[RoryA]

You could make it a decimal field rather than date.

 

[d0hb0y]

You could make it a decimal field rather than date.

This corrected the issue. Thank you!