Forum Discussion
Solved
Return a string from a table based on a date
I wonder if anyone can help......
I have a table:
| Date | Month | AP | Index |
| 01 April 2018 | 4 | AP 1 | 0 |
| 01 May 2018 | 5 | AP 2 | 1 |
| 01 June 2018 | 6 | AP 3 | 2 |
| 01 July 2018 | 7 | AP 4 | 3 |
| 01 August 2018 | 8 | AP 5 | 4 |
| 01 September 2018 | 9 | AP 6 | 5 |
| 01 October 2018 | 10 | AP 7 | 6 |
| 01 November 2018 | 11 | AP 8 | 7 |
| 01 December 2018 | 12 | AP 9 | 8 |
| 01 January 2019 | 1 | AP 10 | 9 |
| 01 February 2019 | 2 | AP 11 | 10 |
| 01 March 2019 | 3 | AP 12 | 11 |
I have a measure in a different table:
Latest Date = MAX('Actuals Data'[Date])
The above measure gives me the date: 1/9/18
What i need is to be able to extract the corresponding 'AP' - in this case it would be 'AP 6'
I will then be using this as a heading in a multi-row card as a title
Thanks for any help
2 Replies
many thanks
