Forum Discussion
mgilbert
9 years agoNew Member
Date range title
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 re...
- Anonymous9 years ago
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.
- 9 years ago
Thanks I will give this a try.
Anonymous
9 years agoNot applicable
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.
- mgilbert9 years agoNew Member
Thanks I will give this a try.