Forum Discussion
Create a Calculated Column from Different Tables
Hi, I have data as in the table below: I need period end dates (month end dates from jan to dec 2018). I was able to create a new table with the required dates. However for my further calculatio...
Hi Stachu,
this formula isn't working either. table 2 is a created table with following data:
The formula used is: Table 2 = FILTER(CALENDAR("01-01-2018",TODAY()),[Date]=EOMONTH([Date],0))
| Date |
| 31 January 2018 |
| 28 February 2018 |
| 31 March 2018 |
| 30 April 2018 |
| 31 May 2018 |
| 30 June 2018 |
| 31 July 2018 |
| 31 August 2018 |
| 30 September 2018 |
Using the formula you mentioned i am only getting new against the dates where live date is end of month. However what i need is this (the client live date of 26th oct is also a new client for october 2018)
Table 1
| Today | Live date | Client ID | Actual status | Status required |
| 26-Oct | 30-Sep | A00034 | new | new |
| 26-Oct | 26-Oct | 12303 | old | new |
| 26-Oct | 05-Oct | 12302 | old | new |
| 26-Oct | 28-Feb | 564735 | new | new |
| 26-Oct | 01-Sep | 102538 | old | new |
| 26-Oct | 15-Sep | 109928 | old | new |
| 26-Oct | 31-Jul | 0928abc | new | new |
| 26-Oct | 26-Oct | 1856XY | old | new |
Hi Anonymous,
Could you please explain the logic of the output? Wht the Status required are all new?
Regards,
Frank