Forum Discussion

CLQ's avatar
CLQ
Helper I
3 years ago
Solved

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

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

2 Replies