Forum Discussion
Relating two tables with missing matches
I'm tearing my hair out trying to work this out! I have 2 tables - one has targets and the other has actuals. I've tried concatenating a column and have an inactive relationship. I then used two c...
Michsara Not sure I understand exactly but try adding + 0 to the end of both formulas. It's a simple trick so that you don't return null/blank and therefore your rows show up.
Hi Greg_Deckler
Unfortunately this hasn't helped. I've mocked up the example in PowerBi. Below are my 2 tables and the joins.
Below is my workbook - for some reason there are some targets missing and I can't work out why. If there is a target but no actual to match, it doesn't show either, but if there is an actual but no target it works