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

1/15/2018  1

1/22/2018  1

1/29/2018  2

2/5/2018    1

2/12/2018  2

and so forth. 

 

Thanks,

Krishna.

 

Need Help

7 Replies

  • CNENFRNL's avatar
    CNENFRNL
    Community Champion
    5 years ago

    Hi, Anonymous , it's merely a matter of clicks on the Power Query UI,

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi,

      Thanks for the reply, I try to follow the steps how ever I could'n see the data column in Transform as if the data column is derived from other date colunm. Please advise is there any other workaround.

      Thanks,

      Krishna.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks for sharing the link, I did try same, however I couln't see the Date column which I should work for in Transform view. On the other, the date column is a derived (new measue) from other date column. Please advise is it something I am missing here.

       

      Sincerely,

      Krishna.

      • sanalytics's avatar
        sanalytics
        Super User
        5 years ago

        Anonymous ,
        the result i have provided is the grouping result..if you want to see the actual data source.then go to the power query editor,duplicate the source and then apply the steps what i have done..

        regards,

        Sanalytics

        if it is your solution then please accept as your solution and like.It will help others to get the right answer quick.

         

         

  • 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.