Forum Discussion
Solved
Matching transactions across multiple tables
Hi everyone, ive come across an issue in my dataset that i need help solving. i have 4 different tables: -travel extract -intermediary file -traveler ID number -traveller card expenses file ...
Hi,
Enter this formula there
=if(ISNUMBER(CALCULATE(COUNTROWS(travel),FILTER(travel,travel[trip date from]<=EARLIER(card_expenses[Transaction Date])&&travel[trip date to]>=EARLIER(card_expenses[Transaction Date])&&travel[Traveller ID]=EARLIER(card_expenses[Employee id])))),"Travel status","Not in travel status")
Thanks Ashish_Mathur!
i'm just curious as to how the last part of the if statement works:
travel[Traveller ID]=EARLIER(card_expenses[Employee id])
what does ''EARLIER'' do in the context of the traveller ID? i understand how it would apply to the trip date from and trip date to but unsure in this context.
Hi,
In simple Engligh that statement says that the ID's in that column should be equal to the ID of the current row.