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 hand, I have a table '110-Actual SCH' that registers the period labor every day for each item.

 

BUT when I try to SUM or perform a LOOKUP I only get data the first day of each month.

 

I tried getting the CWP Total Labor:

 

TEST = LOOKUPVALUE('702-AUX WBS'[CWP Total Labor],'702-AUX WBS'[CWP Cod],'110-Actual SCH'[CWP])
or 
TEST = CALCULATE(SUM('702-AUX WBS'[CWP Total Labor]))
 
 
Thanks for your help
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

5 Replies

  • 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

      Still got data for only the first day of the month. I find it odd