Forum Discussion

aaande8's avatar
aaande8
Frequent Visitor
7 years ago
Solved

Power Pivot Calculate Formula

  Hello,   I am trying to calculate within the Total FTE  column so that it sums the FTE column of the Sheet1 table based on if the Request Completion Date is < the Date the FTE was hire...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    Does this work?

    =CALCULATE(SUM(sheet1[FTE]),FILTER(sheet1,sheet1[Date]<EARLIER('Temp Badge Requests'[Request Completion Date])))

    Hope this helps.

d_gosbell's avatar
d_gosbell
Super User
7 years ago

This error is due to your filter condition, currently you have:

 

'Temp Badge Requests' < 'Temp Badge Requests'[Request Completion Date]

 

The item on the left of the < is a table reference (hence the error about multiple columns, this needs to be a column reference probably to some sort of Hire Date.