Forum Discussion
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 records cover.
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.
Thanks I will give this a try.
2 Replies
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.
Thanks I will give this a try.