I was trying to get an inline reference in my invoice table from my table that have the last 6 approved invoices by vendor. The Key in my invoice table is ProcessID and the key in my last 6 invoice is ProcessID but I want to match them based on vendor not ProcessID and the reference column only seems to work with the key of the table.
Ref columns must have Key values in it, otherwise it wonโt actually link. That being said, however, we can still do what you want with the Key values. However, Iโll need some more information on how your table is constructed. Can you send screenshots of the spreadsheet for those two tables so we can get a quick understanding of how your structure is working?
@Austin_Lambeth
If I have understood you correctly, you want an inline view in your Vendor_Detail View to show the invoices that belong to that particular Vendor. If so:
1.) In your Vendor Table, create a VC with below expression:
SELECT(
Invoice Header[Textract_Process_ID],
AND(
[Vendor ID]=[_THISROW].[Vendor ID],
[Approval_Status]="Approved"
)
)
@Austin_Lambeth
If you only want to show the last 6 invoices, you can try with this instead:
TOP(
ORDERBY(
SELECT(
Invoice Header[Textract_Process_ID],
AND(
[Vendor ID]=[_THISROW].[Vendor ID],
[Approval_Status]="Approved"
)
),
[Invoice_Process_Date],
FALSE
),
6
)
Not in the Vendor_Details sorry. In the Invoice_Header table. The goal is to have an inline view in my Invoice Header view that shows the last 6 approved invoices so the user can compared if the current invoice is outside of the normal margins of the last 6. We already have the last 6 invoices done in database as the view LastSixInvoices.
@Austin_Lambeth
You can use the same expression just with changing the tablename I assume
TOP(
ORDERBY(
SELECT(
Invoice Header[Textract_Process_ID],
[Approval_Status]="Approved"
),
[Invoice_Process_Date],
FALSE
),
6
)
User | Count |
---|---|
41 | |
29 | |
22 | |
20 | |
15 |