UHS
Helper I
1 year agoNeed 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_...
- 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.