Assist with the relationship of different tables - to get my expected results .

[ashmitp869]

Hi,

I need help with the relationship of my tables :

Wants to achieve the result below :

The Posting Date is coming from table Explore_Contract_InvoiceLineItem

Help me with the data model - so that I can achieve my expected results.

sample file

https://github.com/suvechha/samplepbi/blob/main/sample_info%20-%20po.pbix

Thanks

[rajendraongole1]

Hi @ashmitp869  - can you please check the attached file.

Create the following relationships:

Contract[ContractId] → Explore_Contract_InvoiceLineItem[ContractId] (One-to-Many)
Contract[ContractId] → Explore_Contract_PurchaseOrder[ContractId] (One-to-Many)
Explore_Contract_PurchaseOrder[PurchaseOrderNumber] → Explore_Contract_InvoiceLineItem[PurchaseOrderNumber] (One-to-Many)
Ensure all relationships are set to 'Single' direction unless needed for special cases.

added these, please check. getting many to many that relationship please cross check.