How to have card retrieve minimum and maximum date from date filter

[altesv]

Hi I am using the card visual as a title for a dashboard. Let's say my data is filtered to included 1/1/2018 - 7/31/2018.

I use the following dax for my title measure:

 Title = "Report for "&CONCATENATEX(VALUES(Table[Date]),Table[Date]

But when I do this, the title appears as: "Report for 1/1/2018,1/2/2018,1/3/2018..."

The way I would like it to appear is: "Report for 1/1/2018 - 7/31/2018"

Any ideas on how to achieve this?

[Zubair_Muhammad · Accepted solution]

@altesv

What if you simply use MIN and MAX

Title =
"Report for " & MIN ( Table[Date] )
    & " - "
    & MAX ( Table[Date] )