cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CLQ
Helper I
Helper I

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

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!

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.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.