Forum Discussion
mgilbert
9 years agoNew Member
Display a date range in visualization
I have agents call records with the date of the calls, talk time and call counts in a visualization and I want to dislplay the date range as a lable for the full set of records. I know that I can use...
mgilbert
9 years agoNew Member
My goal is to display the min and max date for the entire dataset and only display in once on the visual like a label or a title.
v-huizhn-msft
9 years agoMicrosoft Employee
Hi mgilbert,
You'd better create measures to get the min and max date as follows. Then add the measures to visualization.
Max=CALCULATE(MAX(Table[Date]),ALL(Table)) Min=CALCULATE(MIN(Table[Date]),ALL(Table))
If this doesn't resolve your issue, please share some sample data and expected result. Thanks a lot.
Best Regards,
Angelia