Is there a better place to define this variable?

[Nietzsche]

Hi everyone,

I am looking at a code where variable countryOfBirth is defined inside an argument inside SELECTCOLUMNS which itself is inside another variable.

I wonder if this is the appropciate place to define such variable? Can it be defined outside the SELECTCOLUMNS statement?

thank you.

[Anonymous · Accepted solution]

Hi @Nietzsche,

You can use the FORMAT(INT(RELATED(dimCountry[Code])), "0000") expression directly for later judgment instead of using a variable to store its return value.

But this makes the code very difficult to read and maintain.

If you declare a variable externally and then reassign a value to that variable, you cannot use the RETURN expression later.

Or declare the complete variable directly externally. However, this will not recognize the columns in the /dimCountry/ table.

Therefore, in general, this approach of yours to declaring variables is appropriate.

Best Regards,

Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Nietzsche]

Thank you very much for the detailed explanation.