Last answered:

18 Mar 2024

Posted on:

17 Mar 2024

0

SWITCH() target - taken from a column in a table?

Hi,


is it possible to take the target for that measure from a column in a table and still use SWITCH()?

So it would assign a target to each country and show the indicator for each country accordingly?

Regards

1 answers ( 0 marked as helpful)
Instructor
Posted on:

18 Mar 2024

0

If you have the target stored somewhere you can use switch based on target, but the target would be in general target. If you want to go for target for individual country, I would imagine using a SWITCH and an IF statement.

Submit an answer