cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CLQ
Frequent Visitor

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

1 ACCEPTED SOLUTION
HoangHugo
Solution Specialist
Solution Specialist

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...

View solution in original post

2 REPLIES 2
HoangHugo
Solution Specialist
Solution Specialist

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
Frequent Visitor

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

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Difinity Conference

Difinity Conference 2022

Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand.

European Share Point Conference

European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.