Hello Poweusers,
I have a weird problem.
I want to AddColumns to my datasource, but I need to Filter it aswell. I have no errors if I just use my AddColumns methode as below:
AddColumns(Location;"Equipment ID";LookUp(Equipment;'Location ID'=Location[@'Location ID'];'Equipment ID'))
But when I then try to apply a filter to the first argument of AddColumns like below:
AddColumns(Filter(Location;Route=1);"Equipment ID";LookUp(Equipment;'Location ID'=Location[@'Location ID'];'Equipment ID'))
I suddenly get the error that '=' is an invalid argument type (in the LookUp function)
I have tried so many things, but really do not understand why this is a problem.
Hope someone can help me
Thanks!