Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
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 May 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
15 | |
9 | |
9 | |
8 | |
5 |