Due Date Calculation

[Anonymous]

I am looking for help in generating a due date for an invoice. I have two tables:

1. Terms Table

2. AP Register Table

Terms table is connected to the AP register table with a 1 to many relationship by the Vendor Number. 

I would like to create a new column called Due Date. I also have a column in the Terms table where I extracted the number from the terms. i.e. Net 10=10, Net 30=30, etc.

I wanted to use a DATEADD function, but when I pull up one table, the other one does not come up as an option using DAX. Please help.

Thank you!

[Payeras_BI]

Hi @Anonymous ,

To return a value from another table use RELATED.
E.g.: RELATED('Terms Table' [Your Column])

[Anonymous]

Thank you so much, that helped a lot. I did not know about the RELATED function and have been struggling for a day or so. But now for some reason, I have another issue, where not every Invoice, received a new date. I have several that are blank. I had the same issue when I created a merged table of AP Register and Terms.  Here is an example:

Thank you!

Olga

[Payeras_BI · Accepted solution]

Hi @Anonymous ,

Is the test column in your screenshot the result of using RELATED?

I would check whether all your Vendor Nº in your 'AP register table' exist in your 'Terms table'.

Consider sharing your data or a sample of it for further troubleshooting.