Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
abdelaziz0013
New Member

dax function needed

i have two tables in power pivot in i make relationship between them ,

i need in the second table add new column that get date of the first table related of the second

 

1 REPLY 1
ToddChitt
Super User
Super User

If I understand correctly, Table 1 and Table 2 have a relationship set up. You want a column value from Table 1 to show up as a column in Table 2. Is that right?

What kind of relationship? What granularity? Is it a One-to-Many? If so, which table is on the ONE side? If Table 1 is on the ONE side (or if you have a One-to-One relationship) then you can use this DAX function:

My Value from Table 1 = RELATED ( 'Table 1' [My original Column] )

 

Please mark answers a Solutions if they solve your issue, or give Kudos if they helped in any way.




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!





Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Solution Authors