Need help in calculating Percentage change from previous day count for a table

[sruthicb]

Dear All,
Below is the table  T1 that contains the a table_name and its last_loaded_date and its count and the day which the data was fetched into T1. I would like to calculate the percentage change from previous day of every load so that from the below visualization if I select the particular table and date from dropdown I should get the %change comparing count from previous day to current day. I tried to calculate percentage from previous day but it is calculating for the whole data not for table_name. Could you please provide any tips to calculate. Thank you in advance

Table_name	current_date	count	last_loaded_Date	% change
table1	2020-12-09	500	2020-12-08
table1	2020-12-10	250	2020-12-09
table1	2020-12-11	300	2020-12-10

[daxer-almighty]

Re: How to Get Your Question Answered Quickly - Microsoft Power BI Community