Forum Discussion

MP_123's avatar
MP_123
Microsoft Employee
10 years ago
Solved

time period

hi everyone

 

i created page filter on Date field. for example one week

how can i show on my report the "report period"? to show on the report the including dates in the report

 

thanks!

  • You can create a measure that returns text - something like this

     

    FORMAT( MIN(Dates[Date]), "mm-dd-yyyy") & " to " & FORMAT( MAX(Dates[Date]), "mm-dd-yyyy")

     

    This will return something like "03-24-2016 to 04-04-2016"

5 Replies

  • austinsense's avatar
    austinsense
    Impactful Individual

    You can create a measure that returns text - something like this

     

    FORMAT( MIN(Dates[Date]), "mm-dd-yyyy") & " to " & FORMAT( MAX(Dates[Date]), "mm-dd-yyyy")

     

    This will return something like "03-24-2016 to 04-04-2016"