Return a string from a table based on a date

[timknox]

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

[Anonymous · Accepted solution]

Hi,

="AP "&IF(MONTH([Latest Date])<4,MONTH([Latest Date])+9,MONTH([Latest Date])-3)

[timknox]

many thanks