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...
Need Help
scsi050's avatar
scsi050
Regular Visitor
6 years ago

Hi, 

1) Does this append to the same table by adding a new row upon every refresh?

2)  I am running Power BI Desktop v2.83.5894.881 64-bit (July 2020) which looks like the latest version, but when I open your pbix file, I get the error:

"create trending table.pbix is incompatible with your current version of Microsoft Power BI Desktop. Please install the latest version and try opening the document again".

 

 

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

Hi  scsi050 ,

 

Your version is not the latest one,pls update to the version below:

Version: 2.84.282.0 64-bit (August 2020)

As your result needs to be updated due to every refresh, so measure is the best choice,and when you put the measures in a table visual,it will be added as 1 row in table.

 

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
  • Burningsuit's avatar
    Burningsuit
    Resident Rockstar
    6 years ago

    Hi v-kelly-msft 

    It's 3rd August 2020,  Version: 2.84.282.0 64-bit (August 2020) has not been released yet and is not available for public download. Most people still have the Version: 2.83.5894.961 64-bit (July 2020), only MVP's, Advisors and Microsoft staff have access to the August version at this time.

    Even with that issue, I'm sure your solution will not do what was requested.

    When you refresh the report, the measure  DATE/time will get updated and overwritten with the value in NOW(). The measure Count will get updated and overwritten with the value from COUNT('Table'[Column1]).

    Then you will see..

    DATE/time                               Count

    03/08/2020 09:35:17                        2

    In the Table visualisation

     

    What you will NOT see is what was requested which would be...

    DATE/time                               Count

    31/07/2020 01:42:43 AM                 2

    03/08/2020 09:35:17 AM                 2

     

    As I explained, I don't think there is a way for Power BI to WRITE the data required to generate a Trending Table as requested, you'll have to use SQL or a PowerApp, or Flow.

    I hope this clears things up

    Stuart

     

     

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

      Hi  scsi050 ,

       

      Yes, sorry,as corrected by Burningsuit ,we can only write the current data after refresh,but once you did it,it will overwrite the previous one, a Trending Table is not available as you requested in power bi .

      Sorry again.

       

       
      Best Regards,
      Kelly
      Did I answer your question? Mark my post as a solution!
       
      • scsi050's avatar
        scsi050
        Regular Visitor
        6 years ago

        thanks for the responses.