Forum Discussion

UHS's avatar
UHS
Helper I
1 year ago
Solved

Need help with relationship between two tables

Hi All, I am having two tables between which there is no relation plus there is no unique key to identify unique records. COls from table A to be used Year-Quarter Cost Centre OP_expense_Sub_...
Need Help
  • UHS's avatar
    UHS
    1 year ago

    Hi Everyone, 
    Thanks so much for your replies.
    I found the solution to my problem and here is what i did.
    I created a bridge table between these two tables and added al lth eunique cost centres there and then indivisually joined tables by oneto many relationship as
    Table A many to one relation with Bridge table and Table B many to one relation with Table A and make it active and also filter direction to be selected as both.
    Then createe 2 measures in the table 2 where i wanted to have the logic updated
     Following all these steps my issue gor resolved.

d_m_LNK's avatar
d_m_LNK
Super User
1 year ago

Thanks for the sample data, with which columns are you relating the tables?

UHS's avatar
UHS
Helper I
1 year ago

Thanks for your reply, my issue got resolved by creating a bridge table.

  • v-dineshya's avatar
    v-dineshya
    Community Support
    1 year ago

    Hi UHS ,

    Thanks for the update and happy to know you have found a solution. You can simply post the details of your approach and mark it 'Accept as Solution'. It may help others who may be in similar scenarios.

     

    Thank you.

    • v-dineshya's avatar
      v-dineshya
      Community Support
      1 year ago

      Hi UHS ,

       You can simply post the details of your approach and mark it 'Accept as Solution'. It may help others who may be in similar scenarios.

       

      Thank you.