Forum Discussion
Solved
Help with table relation
So I have two tables Input and Output which has ID and Master ID as foreign key relating to each other. My chart is showing output data while a table below is showing input data. If I add output...
can you share some sample data with us?
It seems to work ok for me
Is that what you're looking for?
https://1drv.ms/u/s!AnIEh6WhI4JogrAAnyDVVkj51F1Xdg?e=v77bfY
I've created a sample PBIX to show you how to achieve this. essentially, I've just merged the two, together then replaced "null" with "No answer"
Did not know this merge function lol. It worked, thank you so much!