Forum Discussion
Create a Calculated Column from Different Tables
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
I need to categorise my data in differnt months. I would add a filter for period end date on my dashboard. So if my users want to take a look at the status at the end of october, they would select october and they would have filtered data available just for october.
For example this is what my dashboard looks like when october month is selected:
New Clients 30 Lost Clients 12 Opening balance 20000 Closing Balance 65000 The data changes to this, when september is selected. An so on.
New Clients 10 Lost Clients 5 Opening balance 8000 Closing Balance 45000 All fields here are calculated fields. How do i categorise my data in power BI? (Can easily do in excel and Tableau)
Hi Anonymous，
Kindly share your pbix. You can upload the file to dropbox and share the link here.
Regards,
Frank