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
Hi, thanks for your reply!
The result I want to show from the two tables, is:
Entry# - date - description - amount(€)
Table 1 shows the description and the amount. Table 2 contains the date and entrynumbers, however the entrynumbers are shown as "entry1 up to entry4", with both the first and last entry# of the 'batch' in different columns.
To see the date for 1 specific entry number, for example entry2, I need to use something like a VLookup would do in Excel, I think. However, I am not able to establish a relationship between the 2 tables at this moment. Do you have any suggestions?
Hi Robin9700 ,
Sorry for delay. I created a sample pbix file(see attachment), please check whether that is what you want.
If the above one is not what you want, please provide some sample data in your tables and your expected result with specific examples and involved logic. Thank you.
Best Regards