Forum Discussion
Cannot active relationship, 2 columns to 1 column
I try to connect cash outflows and inflows from Funding table to Daily CF table.
My tables are something like this:
- Column From in Funding is date of inflow (+ Amount)
- Column To in Funding is date of outflow (- Amount)
- Column Date in Daily CF is just series of whole days in a period
Both From and To should have relationship to Date in Daily CF but I cannot do this in Power BI. I would like to show up Funding inflow/outflow on Daily CF with related information from Funding table (matched by date).
Any suggestion? Please help. Thank you.
Funding
| Drawdown name | Amount | From | To |
| A | 2 | 02/02/2019 | 02/03/2019 |
| B | 2 | 03/03/2019 | 03/05/2019 |
| C | 3 | 04/04/2019 | 04/07/2019 |
Daily CF
| Date | Opex out | Sales out | Collection in |
| 02/02/2019 | |||
| 03/02/2019 | |||
| 04/02/2019 | |||
| 05/02/2019 | |||
| 06/02/2019 | |||
| 07/02/2019 | |||
| 08/02/2019 | |||
| 09/02/2019 | |||
| 10/02/2019 | |||
| 11/02/2019 | |||
| 12/02/2019 |
You can't have two relationships, active at the same time, between two tables. Just one can be active, the other(s) needs to be inactive. That's the way Powerbi works. You have two solutions
- you set one inactive and you activate them when needed using CROSSFILTER and USERELATIONSHIPS
- or you duplicate your date table and have two different,identical, tables,with two relationships (which will be now on two tables)
3 Replies
You can't have two relationships, active at the same time, between two tables. Just one can be active, the other(s) needs to be inactive. That's the way Powerbi works. You have two solutions
- you set one inactive and you activate them when needed using CROSSFILTER and USERELATIONSHIPS
- or you duplicate your date table and have two different,identical, tables,with two relationships (which will be now on two tables)
Thank you, adetogni. I currently use the second way. It works but makes my file pretty large.
