Forum Discussion
Due Date Calculation
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!
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.
3 Replies
Hi Anonymous ,
To return a value from another table use RELATED.
E.g.: RELATED('Terms Table' [Your Column])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
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.