Forum Discussion

CJLittle's avatar
CJLittle
Frequent Visitor
5 years ago
Solved

need help with getting my data visualized properly

Hello all. I have some data that is in a format similar to the following:   Ticket Number Opened Date Closed Date 1 4/6/2021 5/2/2021 2 4/6/2021 4/7/2021 3 4/8/2021 4/15/2021 ...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    5 years ago

    thanks for your reply CJLittle 

    sure, try to change 'Table'[Closed Date] >= _seldate to Table'[Closed Date] > _seldate  in measures

    count = 
var _seldate=SELECTEDVALUE(calendarTable[Date])
return countrows(filter('Table', 'Table'[Opened Date]<=_seldate &&'Table'[Closed Date]>_seldate))

    result

     

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
5 years ago

Hi CJLittle

Your solution looks a bit complicated, would you consider trying an alternative? 😜 it will be simpler.

-

try this measure

count = 
var _seldate=SELECTEDVALUE(calendarTable[Date])
return countrows(filter('Table', 'Table'[Opened Date]<=_seldate &&'Table'[Closed Date]>=_seldate))

 

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.