Forum Discussion
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
Yes, it is possible, you will have an extended version of your "Order Atributte".
Learn more about that
2 Replies
- HoangHugoSolution Specialist
Yes, it is possible, you will have an extended version of your "Order Atributte".
Learn more about that
- CLQHelper I
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