Getting value from a field based on a corresponding column
Hello, I'm struggling with something that seems very simple yet I spent quite some time on it and have not found a straightforward answer.
What I need to do is to extract a value from a table based on a value of a corresponding column. The table has 2 columns: id and name. I want to use it for labelling measures on a chart which is based on various tables. So it would be something like = name(id=2). Can someone help?