Different column into one Column

[legato]

I have a table with column:

table A
(int) (int) (int) (int)
PK_g cost FK_a FK_b
123 5 23 55
454 5 234 58

I need to create a superkey as an additional column in the table A by using DAX code. How should I do it? It would be a calculated column.
The result should be by combining PK_g and FK_a.

New requested column named:

superkey
--------
12323
454234


Info:
- The Superkey will be acting as a unique identifier for each row in tabular.
- The DAX code take place in SSAS tabular.
- I don't want the code to be formatted with this context. If value is 100123, would like to be "100123" not "100 123".
- Can the value be output as int or text?

 

[Laurent C]

You can and should concatenate both values.

You can use CONCATENATE function, the & operator, or some numerical expression, if you want your superkey to be an int - I do not see any obvious advantage to having an integer key though.

 

[legato]

Thank you for your help!​