Forum Discussion
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...
Hi,
Does this work?
=CALCULATE(SUM(sheet1[FTE]),FILTER(sheet1,sheet1[Date]<EARLIER('Temp Badge Requests'[Request Completion Date])))
Hope this helps.
Yeah this worked. Thanks so much!
You are welcome.