Forum Discussion
How to Archive Daily Count in PowerBI?
Hello guys, I have connected the SQL Table with PowerBI where it will produce "Total Count" till date. I need to Create the Trend Chart by showing "Total Count" of each Day. I need to aggregate or Increment the Count by storing the value in a table for each date.
Example: Assume,
When I refreshed Yesterday, it will show the "Total Count" as 100,
When I refresh Today, it will show the "Total Count" as 150,
When I refresh Tomorrow, it will show the "Total Count" as 180.
But I need a table to store/show as below,
| Yesterday Date (15/8/2022) | 100 |
| Today Date (16/8/2022) | 50 |
| Tomorrow Date (17/8/2022) | 30 |
That table has to be somewhere else. Power BI has no memory, and no concept of global variables. You need to do that in the upstream system.
1 Reply
- lbendlin
Super User
That table has to be somewhere else. Power BI has no memory, and no concept of global variables. You need to do that in the upstream system.