Forum Discussion
Relation based on two columns
Hi Robin9700 ,
I created another new sample pbix file(see attachment) base on the data of your provided tables, please check whether that is what you want.
Best Regards
Anonymous Thanks again for your reply!
Table 2 is indeed exactly what I need.
Table 1 is like the one I already have.
I see I am not allowed to upload files and/or images, so I will try to explain this again.
Table 1 looks like this:
| Description | Entry number | Amount |
| Purchase of goods | 1 | €100 |
| Purchase of goods | 2 | €350 |
| Purchase of goods | 3 | €20 |
| Sales | 4 | €125 |
| Sales | 5 | €250 |
| Purchase of goods | 6 | €50 |
| Purchase of goods | 7 | €100 |
| Purchase of goods | 8 | €10 |
And the other table I have (which is not in your file) looks like this:
| Date | Description | First entry number | Last entry number |
| May 12, 2021 | Purchase of goods | 1 | 3 |
| May 17, 2021 | Sales | 4 | 5 |
| May 20, 2021 | Purchase of goods | 6 | 8 |
And what I need right now, is a way to connect or merge those 2, to eventually create visuals with the following data (like table 2 in your file):
| Date | Description | Entry number | Amount |
| May 12, 2021 | Purchase of goods | 2 | €350 |
| May 17, 2021 | Sales | 4 | €125 |
| May 20, 2021 | Purchase of goods | 6 | €50 |
| May 12, 2021 | Purchase of goods | 1 | €20 |
So basically, what I need, is table 1 & 2 to form table 3 together. Can you help me with that?
Hi Robin9700 ,
I created another new sample pbix file(see attachment) base on the data of your provided tables, please check whether that is what you want.
Best Regards
Thank you so much! I was able to recreate the 'Entries' column and expand it, and now my data does what it should do 🙂
Have a good day!