Forum Discussion
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...
Hi JOSERB ,
Try this calcultated column:
Value =
VAR _date = CALCULATE(MIN('Table (2)'[DATE]); FILTER('Table (2)'; 'Table (2)'[ID] = EARLIER('Table'[ID]) && 'Table (2)'[DATE] >= EARLIER('Table'[DATE])))
RETURN CALCULATE(DISTINCT('Table (2)'[VALUE]); FILTER('Table (2)'; 'Table (2)'[ID] = EARLIER('Table'[ID]) && 'Table (2)'[DATE] = _date))
it worked! thank you so much guys 🙂