Forum Discussion

mrothschild's avatar
mrothschild
Continued Contributor
7 years ago
Solved

adding columns to re-flatten data?

This strikes me as solving a problem that the architecture is meant to avoid, but I have two related tables.  The first: SummaryInput, has unique rows of [Asset ID].  The second, AssetReturn, has a b...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

     

    In the Asset return Table, write this calculated column formula

     

    =RELATED(SummaryInput[Yield])

     

    Hope this helps.

mrothschild's avatar
mrothschild
Continued Contributor
7 years ago

Thanks.  My Excel tables had blanks in them so the [AssetID] that was linking was a "many-to-many" relationship that BI apparently didn't like at all.  Once I removed the extra blanks from my Excel table, this worked perfectly.  

 

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

Glad to hear that.  If my reply helped, please mark it as Answer.