Hi All,
I can only create measures, not columns.
I have created a page filter for the date column, and I want to filter the 'most recent date' for example 21/12/2019, and also the last three dates which are the last day in the previous months.
When the database updates overnight, the most recent date changes, for example, 21/12/2019 to 22/12/2019.
My page filter then removes the most recent but does not select the new most recent. 22/12/2019.
Is there a way i can solve this with a mesasure.
I already have a measure built into the database which is a most recent flag.. this show a 1 on all rows with the most recent date, and a 0 on all other row.
Thanks in advance for any help.
| date | measure1 | measure 2 |
| 31/07/2019 | a | 12 |
| 31/07/2019 | b | 12 |
| 31/07/2019 | c | 1 |
| 31/08/2019 | a | 1 |
| 31/08/2019 | b | 2 |
| 31/08/2019 | c | 6 |
| 30/09/2019 | a | 3 |
| 30/09/2019 | b | 3 |
| 30/09/2019 | c | 5 |
| 31/10/2019 | a | 4 |
| 31/10/2019 | b | 3 |
| 30/11/2019 | a | 2 |
| 30/11/2019 | b | 1 |
| 21/12/2019 | a | 1 |
| 21/12/2019 | b | 2 |
