Need help on Dynamic Title based on date range

[coolshib]

Hi Everyone,

Heed help of Dynamic Title based on date range filtered in slicer.

For example, if i select the date range as from 01/04/2019 to 15/04/2019 then the title should display as 

"Sales report for the period 01/04/2019 to 15/04/2019".

My sales data is as follows

Sale Date	Item	Units	Total
01/04/2019	Pencil	95	189.05
02/04/2019	Binder	50	999.5
03/04/2019	Pencil	36	179.64
04/04/2019	Pen	27	539.73
05/04/2019	Pencil	56	167.44
06/04/2019	Binder	60	299.4
07/04/2019	Pencil	75	149.25
08/04/2019	Pencil	90	449.1
09/04/2019	Pencil	32	63.68
10/04/2019	Binder	60	539.4
11/04/2019	Pencil	90	449.1
12/04/2019	Binder	29	57.71
13/04/2019	Binder	81	1,619.19
14/04/2019	Pencil	35	174.65
15/04/2019	Desk	2	250
16/04/2019	Pen Set	16	255.84
17/04/2019	Binder	28	251.72
18/04/2019	Pen	64	575.36
19/04/2019	Pen	15	299.85

Thanks in advance.

Best Regards,

Shib

[welbywelb]

Hi,

I think this answer is only correct if the data in Sheet1 has a record for the filtered start and end date so it does not give the correct result if we filtered from 1-Sep-2021 to 17-Sep-2021 and Sheet1 only contains data from the 2-Sep-2021 to 16-Sep-2021 as this would give the results of " Sales report for the period 2-Sep-2021 to 16-Sep-2021" .. which is clearly not show the filtered date range.

[Anonymous · Accepted solution]

This should work for you:

Measure = "Sales report for the period " & FIRSTDATE(Sheet1[Dates]) & " to " & LASTDATE(Sheet1[Dates])