Forum Discussion

mgilbert's avatar
mgilbert
New Member
9 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

How about creating 'From Date' and 'To Date' measures (or similar names) using MIN and MAX as you've suggested, then displaying these on a Multi-Row Card visual?

mgilbert's avatar
mgilbert
New Member
9 years ago

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's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    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