Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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.
Proud to be a Super User! | |
Check out the July 2025 Power BI update to learn about new features.