Is it possible create a column inside a variable, "emulating" a related?

[CLQ]

Hi, good morning (or good afternoon or good evening). I want to know if the following is possible:
I have two tables, I created a column in the 'Order Attributes' table thanks to the relationship between them:

Store_ID = RELATED('Business - Store'[STORE_NK])

​
Then, I used that column for a calculation in Dax on another column. Something like that:

TypeofStore = var StoreId=[Store_ID]
var StoreName=SELECTEDVALUE('Order Attributes'[operator_nk])
var selectdate='Order Attributes'[Order Date]
......
return
.....
(I don't write all the code because I don't think it's necessary)

So let's say I don't want to have so many columns inside the table 'Order Attributes' and I want to remove the Store_ID column. For that, I would like to "create" a column in a variable, i.e. I am trying to emulate/copy

Store_ID = RELATED('Business - Store'[STORE_NK])​

And write something like this:

TypeofStore =
var StoreId=ADDCOUMNS('Order Attributes', "Store_ID", RELATED('Business - Store'[STORE_NK])
var StoreName=SELECTEDVALUE('Order Attributes'[operator_nk])
var selectdate='Order Attributes'[Order Date]
......
return

It's possible?

Thank you

[HoangHugo · Accepted solution]

Yes, it is possible, you will have an extended version of your "Order Atributte".

Learn more about that

https://learn.microsoft.com/en-us/dax/addcolumns-function-dax?ranMID=46131&ranEAID=a1LgFw09t88&ranSi...

[CLQ]

The addcolumn should work? I get an error, that's why my question was referring to whether there was any formula where the variable that I tried to create is emulated.

But if it's possible with just an addcolumn, then I must be doing something wrong. thanks