Date range title

[mgilbert]

I have a file with call data that contains call dates. I want to be able to have my visualiztion that shows call count and talk time of each agent to also have a title with the date range that the records cover.

[Anonymous · Accepted solution]

You can do a Firstdate = Min([Date]) and LastDate = Max([Date]) measure, then a last measure DateRange = Concatanate(concatanate([FirstDate]," - "),[LastDate])).  Use a Card visual and DateRange as the measure.  

If you have any questions for me, you can reach me via LinkedIn or in the PowerBI Community.

[Anonymous · Accepted solution]

You can do a Firstdate = Min([Date]) and LastDate = Max([Date]) measure, then a last measure DateRange = Concatanate(concatanate([FirstDate]," - "),[LastDate])).  Use a Card visual and DateRange as the measure.  

If you have any questions for me, you can reach me via LinkedIn or in the PowerBI Community.

[mgilbert · Accepted solution]

Thanks I will give this a try.