topic Need help in calculating Percentage change from previous day count for a table in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-help-in-calculating-Percentage-change-from-previous-day/m-p/1538490#M30256 <P>Dear All,<BR />Below is the table&nbsp; 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 provid<SPAN>e any tips to calculate. Thank you in advance</SPAN></P><P>&nbsp;</P><P><img /></P><TABLE border="1"><TBODY><TR><TD>Table_name</TD><TD>current_date</TD><TD>count</TD><TD>last_loaded_Date</TD><TD>% change</TD></TR><TR><TD>table1</TD><TD>2020-12-09</TD><TD>500</TD><TD>2020-12-08</TD><TD>&nbsp;</TD></TR><TR><TD>table1</TD><TD>2020-12-10</TD><TD>250</TD><TD>2020-12-09</TD><TD>&nbsp;</TD></TR><TR><TD>table1</TD><TD>2020-12-11</TD><TD>300</TD><TD>2020-12-10</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P> Wed, 23 Dec 2020 10:55:57 GMT sruthicb 2020-12-23T10:55:57Z Need help in calculating Percentage change from previous day count for a table https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-help-in-calculating-Percentage-change-from-previous-day/m-p/1538490#M30256 <P>Dear All,<BR />Below is the table&nbsp; 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 provid<SPAN>e any tips to calculate. Thank you in advance</SPAN></P><P>&nbsp;</P><P><img /></P><TABLE border="1"><TBODY><TR><TD>Table_name</TD><TD>current_date</TD><TD>count</TD><TD>last_loaded_Date</TD><TD>% change</TD></TR><TR><TD>table1</TD><TD>2020-12-09</TD><TD>500</TD><TD>2020-12-08</TD><TD>&nbsp;</TD></TR><TR><TD>table1</TD><TD>2020-12-10</TD><TD>250</TD><TD>2020-12-09</TD><TD>&nbsp;</TD></TR><TR><TD>table1</TD><TD>2020-12-11</TD><TD>300</TD><TD>2020-12-10</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P> Wed, 23 Dec 2020 10:55:57 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-help-in-calculating-Percentage-change-from-previous-day/m-p/1538490#M30256 sruthicb 2020-12-23T10:55:57Z Re: Need help in calculating Percentage change from previous day count for a table https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-help-in-calculating-Percentage-change-from-previous-day/m-p/1541088#M30331 <P><A href="https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1521338#M626461" target="_blank">Re: How to Get Your Question Answered Quickly - Microsoft Power BI Community</A></P> Wed, 09 Dec 2020 14:16:37 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-help-in-calculating-Percentage-change-from-previous-day/m-p/1541088#M30331 daxer-almighty 2020-12-09T14:16:37Z