Forum Discussion
JOSERB
6 years agoFrequent Visitor
INDEX MATCH in PBI / Merged Tables ?
Hello all, I would like to thank you all for your help. I am a rookie in PBI and you are saving my life vey often (I would not have enough money to pay all the beers I should pay XD) . Unfortuna...
amitchandak
6 years agoSuper User
JOSERB , Create a new column in T1 like one of these
countx(filter(T1, T1[ID1] =T2[ID2] && T1[DATE.1] =T2[DATE.2]),T2[VALUE])
Or
Minx(filter(T1, T1[ID1] =T2[ID2] && T1[DATE.1] =T2[DATE.2]),T2[VALUE])
You can use for calculation