Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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! | |
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!