Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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 October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
69 | |
61 | |
18 | |
16 | |
13 |