Forum Discussion

coolshib's avatar
coolshib
Helper III
6 years ago
Solved

Need help on Dynamic Title based on date range

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 re...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    This should work for you:

     

    Measure = "Sales report for the period " & FIRSTDATE(Sheet1[Dates]) & " to " & LASTDATE(Sheet1[Dates])
welbywelb's avatar
welbywelb
New Member
4 years ago

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.