Forum Discussion

vin90's avatar
vin90
Regular Visitor
2 years ago
Solved

Groupby and lookup values between tables using DAX

Hi Community. Could you please help me wth the following scenario? I have tables: Table_1 and Table_2. I am trying to populate column Desired_Value in Table_1.  This Desired_Value column should bas...
Need Help
Tips and Tricks
  • lbendlin's avatar
    lbendlin
    2 years ago
    Desired Value = 
var i = [ID]
var b = Filter(Table_2,Table_2[ID]=i && Table_2[Date] in GENERATESERIES([Start_Date],[End_Date]))
return sumx(b,[Ind_Value])

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago
Desired Value = 
var i = [ID]
var b = Filter(Table_2,Table_2[ID]=i && Table_2[Date] in GENERATESERIES([Start_Date],[End_Date]))
return sumx(b,[Ind_Value])

 

vin90's avatar
vin90
Regular Visitor
2 years ago

Thanks lbendlin. This is exactly what I was looking for.