Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Summarize data by Date

Hi I am new to Power Bi. I am trying to display count of data by date. Please suggest how to proceede, my data is like below. I was hoping to display data in a table like below 1/1/2018    2...
Need Help
v-yingjl's avatar
v-yingjl
Community Support
5 years ago

Hi Anonymous ,

Just create an count measure:

Measure = COUNT('Table'[Date])

 

Best Regards,
Yingjie Li

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks for the respone, I tried the same but no luck. However, I was able to get it fixed, the summarization is not working because Power Bi not able to reade Date column as date. When I try to apply format to date it started working fine. Appreciate for time and inputs provided. 

     

    Regards,

    Krishna.