How to Archive Daily Count in PowerBI?

[Beast]

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

[lbendlin · Accepted solution]

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.