Forum Discussion
Link proposal to application
I've two tables Application and proposal.
Application
ApplicationId|proposalid| accepted bank| approvedAmount|creationdate
Proposal
ApplicationID|proposalid|bank|proposalamount|internalreject(yes/no) |approved amount
For each application, there's only one accepted proposal,
the difference between approved_amount from proposals and approved_amount from applications
application.approved_amount = MAX(application.proposals.amount)
application.proposals.amount = each banks proposals approved amount.
But each application may have multiple proposals, even multiple proposals per bank per application.
Internalreject is a filter yes or no.
I'd like to have a table like this only for internalreject =yes
Bank|proposalamount|approvedAmount|creationdate
I tried to do one to many relationships from application to proposal but it didn't return correct results, how to correct it please?
1 Reply
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with. Avoid posting screenshots of your source data if possible.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
