Forum Discussion

scsi050's avatar
scsi050
Regular Visitor
6 years ago

create trending table

I am trying to find a way to create trending data within PowerBI.   I have table2 that gets updated with each refresh and upon each refresh, I would like a new row to be appended to an existing table.  The table would have the current date/time in the first row and a count of the number of rows from table2.

Then with that table of trending data I would graph it.

 

Is this possible? thanks

 

Need Help

12 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    6 years ago

    Hi there

     

    Could you please give some sample data and then also an expected result to assist?

    • scsi050's avatar
      scsi050
      Regular Visitor
      6 years ago

      Example of table2:

       

      Column1,column2

      Abc,123

      Cde,456

       

      Trending table:

      Date,count

      7/29/2020,<count of rows in table2 as of 7/29 refresh>

      7/30/2020,<count of rows in table2 for today's refresh>

       

      ...and so on

       

      Then I can visually show a graph of how the count of table2 rows differs as time goes on.

      • v-kelly-msft's avatar
        v-kelly-msft
        Community Support
        6 years ago

        Hi  scsi050 ，

         

        Create 2 measures as below:

        DATE/time = NOW()
        Count = COUNT('Table'[Column1])

        Then you will see：

        For the related .pbix file,pls see attached.

         

        Best Regards,
        Kelly
        Did I answer your question? Mark my post as a solution!