Anonymous_Naq
New Member
Here is my data in excel :
IssuedBooks :
BookInventryDetail
AccessLevel-
This is the way my tables are linked in power bi
![1708545985525.png 1708545985525.png](https://chandoo.org/forum/data/attachments/86/86670-0973590ec91a4611be74f40394d4efd9.jpg)
I am creating a simple test table where the output looks like this -
![1708540857512.png 1708540857512.png](https://chandoo.org/forum/data/attachments/86/86669-7737541ecc3a24794729d260310fd367.jpg)
But The correct output is
Why is it not choosing BookQty, Days corresponding to the BookCode? Why is it choosing extra records? Why the join is not working?
IssuedBooks :
date | EmployeeID | Book |
01-02-21 | 1 | 45 |
02-05-21 | 1 | 56 |
05-07-21 | 2 | 78 |
BookInventryDetail
BookCode | Book | BookQty | Days |
A | 45 | 2 | 7 |
A | 56 | 3 | 3 |
A | 78 | 1 | 999 |
B | 45 | 123 | 10 |
B | 56 | 555 | 30 |
B | 78 | 666 | 40 |
AccessLevel-
EmployeeID | BookCode |
1 | A |
2 | A |
This is the way my tables are linked in power bi
![1708545985525.png 1708545985525.png](https://chandoo.org/forum/data/attachments/86/86670-0973590ec91a4611be74f40394d4efd9.jpg)
I am creating a simple test table where the output looks like this -
![1708540857512.png 1708540857512.png](https://chandoo.org/forum/data/attachments/86/86669-7737541ecc3a24794729d260310fd367.jpg)
But The correct output is
EmployeeID | Book | BookCode | BookQty | Days |
1 | 45 | A | 2 | 7 |
1 | 56 | A | 3 | 3 |
2 | 78 | B | 666 | 40 |
Why is it not choosing BookQty, Days corresponding to the BookCode? Why is it choosing extra records? Why the join is not working?
Attachments
Last edited: