Forum Discussion

LuZeta_39's avatar
LuZeta_39
Frequent Visitor
4 years ago
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...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

LuZeta_39 , Using the date column of '110-Actual SCH' you can create a column like this

 

TEST = Maxx(filtwe('702-AUX WBS','702-AUX WBS'[CWP Cod] ='110-Actual SCH'[CWP] && '110-Actual SCH'[Date] = eomonth('110-Actual SCH'[Date],0) +1 ) '702-AUX WBS'[CWP Total Labor])

 

then create measure to so sum of this

sum('110-Actual SCH'[TEST])

LuZeta_39's avatar
LuZeta_39
Frequent Visitor
4 years ago

Thanks for your help.

 

I tried 

TEST = Maxx(FILTER('702-AUX WBS','702-AUX WBS'[CWP Cod] ='110-Actual SCH'[CWP] && '110-Actual SCH'[Fecha] = eomonth('110-Actual SCH'[Fecha],0) +1 ),'702-AUX WBS'[CWP Total Labor])
 
Got blank results:

 

 

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    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's avatar
      LuZeta_39
      Frequent Visitor
      4 years ago

      Problem solved. There was a double way relationship beetween aux and a table that has monthly data.

       

      Thanks for your help.