Forum Discussion
RonaldvdH
Post Patron
Post PatronWhat's wrong with my formula
Hey guys, I need help in fixing my formula. Basically I have a table which contains Forecast hours and Spend hours. When the Spend Hours has a value it overrules the Forecast Hours. I want to ca...
RonaldvdHPost Patron
Post PatronMahesh0016 here is the screenshot for FC Uren
The formula in the measure 'Totaal geboekte uren' is
Totaal geboekte uren = CALCULATE(SUM('DWH Uren'[PT Taakuren]),USERELATIONSHIP('FC Uren'[Week+Kenmerk],'DWH Uren'[Week+Kenmerk]))
The calculted column is based on a vertical search from another table
Geboekte uren = VAR __Kenmerk1 = 'FC Uren'[Week+Kenmerk]
VAR __Kenmerk2 = FILTER(ALL('test2'),test2[Weeknummer TD datum+Activiteit] = __Kenmerk1)
RETURN
MAXX(__Kenmerk2,[Aantal geboekte uren])
RonaldvdHPost Patron
Post PatronTo further clarify my question I've made this screenshot.
For that specific project I think we'll use 15 hours per week but in reality we've used 17, 16.75, 13 and 19,5 hours.
That means, based on the 15 hours I've forecasted I have a deviation