Forum Discussion

clteh9's avatar
clteh9
Icon for Helper I rankHelper I
3 years ago
Solved

count by categories and date

hi, 

 

i would like to check how can i format the visual as below. 

 

this is my sample data.

Thanks in advance. 

 

Need Help

7 Replies

  • mangaus1111's avatar
    mangaus1111
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Hi clteh9 ,

    create a calculated column 

    End Date = INT([end time])

     

     and then a measure 

    Count = COUNTROWS('Table')

     

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

    • clteh9's avatar
      clteh9
      Icon for Helper I rankHelper I
      3 years ago

      i tried it in the power bi. it show the report as such instead of showing category and subcategory in diff columns. Can help? thanks

  • mangaus1111's avatar
    mangaus1111
    Icon for Solution Sage rankSolution Sage
    3 years ago

    clteh9 ,

    sorry the calculated column must be like this

     

    End Date = CONVERT(INT('Table'[End Time]),DATETIME)
     
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.