Forum Discussion
Solved
VLOOKUP Applying for months
Hello everyone, I have this '702-AUX WBS' table that has the total for each Item named CWP Cod. It's important to remark that this table doesnt have any date involved. In the other ha...
LuZeta_39 , sorry small correction
TEST = Maxx(FILTER('702-AUX WBS','702-AUX WBS'[CWP Cod] ='110-Actual SCH'[CWP] && '110-Actual SCH'[Fecha] = eomonth('110-Actual SCH'[Fecha],-1) +1 ),'702-AUX WBS'[CWP Total Labor])
Hope there are few start date of the month
LuZeta_39 , sorry small correction
TEST = Maxx(FILTER('702-AUX WBS','702-AUX WBS'[CWP Cod] ='110-Actual SCH'[CWP] && '110-Actual SCH'[Fecha] = eomonth('110-Actual SCH'[Fecha],-1) +1 ),'702-AUX WBS'[CWP Total Labor])
Hope there are few start date of the month
Problem solved. There was a double way relationship beetween aux and a table that has monthly data.
Thanks for your help.