Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only

Report showing sequential days updated daily

  • 1.  Report showing sequential days updated daily

    Posted Sep 22, 2022 08:52 AM
    I need to track the number of customers that exist in my database and the quantity changes daily.  So for example the number of customers might be 100 on 1/1 and 114 on 1/2.  What I need to do is create a report that shows 1/1 = 100 and then 1/2 = 114 and then 1/3 = 106.  I need to append the results of a query to the internal table that I have in my power bi report.  If this is not possible, I can look at doing it in the source database.  The key is that since the query counts the number of customers on a daily basis, I need to retain the previous day's result in the table and only add the new entry from the current day.

    I hope this makes sense.  I tried using an append query but it only overwrites the previous day's record and I end up with two records, the original record and then the new entry.

    Tim Vavra
    Sr. Analyst