topic Asset Life Cycle Prediction Date in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Asset-Life-Cycle-Prediction-Date/m-p/2480604#M67872 <P>Hello!</P><P>&nbsp;</P><P>I have a database with daily equipment operating time (uptime), and I'd like to preview when I achieve the lifecycle. I've read articles about linear regression, but I'm not finding the date I need.</P><P>&nbsp;</P><P>My panel looks like this, and I want to have the date as shown on the card "Estimated Lifecycle Achievement". I'll filter an asset and see its KPIs. I have the lifecycle information, it's like 40,000 hours</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>Here is an real example of an equipment uptime registration.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>SiteId</TD><TD>Reading</TD><TD>MeterType</TD><TD>TakenDate</TD><TD>TakenBy</TD><TD>Uptime</TD><TD>AssetNumber</TD></TR><TR><TD>055</TD><TD>22350,0</TD><TD>HOURS</TD><TD>2019-11-13</TD><TD>IMPORT</TD><TD>0,00</TD><TD>LR12345</TD></TR><TR><TD>055</TD><TD>22359,5</TD><TD>HOURS</TD><TD>2019-11-14</TD><TD>INTERPOLATE</TD><TD>9,50</TD><TD>LR12345</TD></TR><TR><TD>055</TD><TD>22369,0</TD><TD>HOURS</TD><TD>2019-11-15</TD><TD>IMPORT</TD><TD>9,50</TD><TD>LR12345</TD></TR><TR><TD>055</TD><TD>22376,7</TD><TD>HOURS</TD><TD>2019-11-16</TD><TD>INTERPOLATE</TD><TD>7,67</TD><TD>LR12345</TD></TR><TR><TD>055</TD><TD>22384,3</TD><TD>HOURS</TD><TD>2019-11-17</TD><TD>INTERPOLATE</TD><TD>7,67</TD><TD>LR12345</TD></TR><TR><TD>055</TD><TD>22392,0</TD><TD>HOURS</TD><TD>2019-11-18</TD><TD>IMPORT</TD><TD>7,67</TD><TD>LR12345</TD></TR><TR><TD>055</TD><TD>22408,0</TD><TD>HOURS</TD><TD>2019-11-19</TD><TD>IMPORT</TD><TD>16,00</TD><TD>LR12345</TD></TR><TR><TD>055</TD><TD>22413,0</TD><TD>HOURS</TD><TD>2019-11-20</TD><TD>IMPORT</TD><TD>5,00</TD><TD>LR12345</TD></TR><TR><TD>055</TD><TD>22434,0</TD><TD>HOURS</TD><TD>2019-11-21</TD><TD>IMPORT</TD><TD>21,00</TD><TD>LR12345</TD></TR><TR><TD>055</TD><TD>22443,0</TD><TD>HOURS</TD><TD>2019-11-22</TD><TD>IMPORT</TD><TD>9,00</TD><TD>LR12345</TD></TR><TR><TD>055</TD><TD>22445,0</TD><TD>HOURS</TD><TD>2019-11-23</TD><TD>INTERPOLATE</TD><TD>2,00</TD><TD>LR12345</TD></TR><TR><TD>055</TD><TD>22447,0</TD><TD>HOURS</TD><TD>2019-11-24</TD><TD>INTERPOLATE</TD><TD>2,00</TD><TD>LR12345</TD></TR><TR><TD>055</TD><TD>22449,0</TD><TD>HOURS</TD><TD>2019-11-25</TD><TD>IMPORT</TD><TD>2,00</TD><TD>LR12345</TD></TR><TR><TD>055</TD><TD>22460,0</TD><TD>HOURS</TD><TD>2019-11-26</TD><TD>IMPORT</TD><TD>11,00</TD><TD>LR12345</TD></TR><TR><TD>055</TD><TD>22475,0</TD><TD>HOURS</TD><TD>2019-11-27</TD><TD>IMPORT</TD><TD>15,00</TD><TD>LR12345</TD></TR><TR><TD>055</TD><TD>22479,0</TD><TD>HOURS</TD><TD>2019-11-28</TD><TD>INTERPOLATE</TD><TD>4,00</TD><TD>LR12345</TD></TR><TR><TD>055</TD><TD>22483,0</TD><TD>HOURS</TD><TD>2019-11-29</TD><TD>INTERPOLATE</TD><TD>4,00</TD><TD>LR12345</TD></TR><TR><TD>055</TD><TD>22487,0</TD><TD>HOURS</TD><TD>2019-11-30</TD><TD>INTERPOLATE</TD><TD>4,00</TD><TD>LR12345</TD></TR><TR><TD>055</TD><TD>22491,0</TD><TD>HOURS</TD><TD>2019-12-01</TD><TD>INTERPOLATE</TD><TD>4,00</TD><TD>LR12345</TD></TR></TBODY></TABLE> Wed, 27 Apr 2022 13:26:23 GMT JOSEAFC 2022-04-27T13:26:23Z Asset Life Cycle Prediction Date https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Asset-Life-Cycle-Prediction-Date/m-p/2480604#M67872 <P>Hello!</P><P>&nbsp;</P><P>I have a database with daily equipment operating time (uptime), and I'd like to preview when I achieve the lifecycle. I've read articles about linear regression, but I'm not finding the date I need.</P><P>&nbsp;</P><P>My panel looks like this, and I want to have the date as shown on the card "Estimated Lifecycle Achievement". I'll filter an asset and see its KPIs. I have the lifecycle information, it's like 40,000 hours</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>Here is an real example of an equipment uptime registration.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>SiteId</TD><TD>Reading</TD><TD>MeterType</TD><TD>TakenDate</TD><TD>TakenBy</TD><TD>Uptime</TD><TD>AssetNumber</TD></TR><TR><TD>055</TD><TD>22350,0</TD><TD>HOURS</TD><TD>2019-11-13</TD><TD>IMPORT</TD><TD>0,00</TD><TD>LR12345</TD></TR><TR><TD>055</TD><TD>22359,5</TD><TD>HOURS</TD><TD>2019-11-14</TD><TD>INTERPOLATE</TD><TD>9,50</TD><TD>LR12345</TD></TR><TR><TD>055</TD><TD>22369,0</TD><TD>HOURS</TD><TD>2019-11-15</TD><TD>IMPORT</TD><TD>9,50</TD><TD>LR12345</TD></TR><TR><TD>055</TD><TD>22376,7</TD><TD>HOURS</TD><TD>2019-11-16</TD><TD>INTERPOLATE</TD><TD>7,67</TD><TD>LR12345</TD></TR><TR><TD>055</TD><TD>22384,3</TD><TD>HOURS</TD><TD>2019-11-17</TD><TD>INTERPOLATE</TD><TD>7,67</TD><TD>LR12345</TD></TR><TR><TD>055</TD><TD>22392,0</TD><TD>HOURS</TD><TD>2019-11-18</TD><TD>IMPORT</TD><TD>7,67</TD><TD>LR12345</TD></TR><TR><TD>055</TD><TD>22408,0</TD><TD>HOURS</TD><TD>2019-11-19</TD><TD>IMPORT</TD><TD>16,00</TD><TD>LR12345</TD></TR><TR><TD>055</TD><TD>22413,0</TD><TD>HOURS</TD><TD>2019-11-20</TD><TD>IMPORT</TD><TD>5,00</TD><TD>LR12345</TD></TR><TR><TD>055</TD><TD>22434,0</TD><TD>HOURS</TD><TD>2019-11-21</TD><TD>IMPORT</TD><TD>21,00</TD><TD>LR12345</TD></TR><TR><TD>055</TD><TD>22443,0</TD><TD>HOURS</TD><TD>2019-11-22</TD><TD>IMPORT</TD><TD>9,00</TD><TD>LR12345</TD></TR><TR><TD>055</TD><TD>22445,0</TD><TD>HOURS</TD><TD>2019-11-23</TD><TD>INTERPOLATE</TD><TD>2,00</TD><TD>LR12345</TD></TR><TR><TD>055</TD><TD>22447,0</TD><TD>HOURS</TD><TD>2019-11-24</TD><TD>INTERPOLATE</TD><TD>2,00</TD><TD>LR12345</TD></TR><TR><TD>055</TD><TD>22449,0</TD><TD>HOURS</TD><TD>2019-11-25</TD><TD>IMPORT</TD><TD>2,00</TD><TD>LR12345</TD></TR><TR><TD>055</TD><TD>22460,0</TD><TD>HOURS</TD><TD>2019-11-26</TD><TD>IMPORT</TD><TD>11,00</TD><TD>LR12345</TD></TR><TR><TD>055</TD><TD>22475,0</TD><TD>HOURS</TD><TD>2019-11-27</TD><TD>IMPORT</TD><TD>15,00</TD><TD>LR12345</TD></TR><TR><TD>055</TD><TD>22479,0</TD><TD>HOURS</TD><TD>2019-11-28</TD><TD>INTERPOLATE</TD><TD>4,00</TD><TD>LR12345</TD></TR><TR><TD>055</TD><TD>22483,0</TD><TD>HOURS</TD><TD>2019-11-29</TD><TD>INTERPOLATE</TD><TD>4,00</TD><TD>LR12345</TD></TR><TR><TD>055</TD><TD>22487,0</TD><TD>HOURS</TD><TD>2019-11-30</TD><TD>INTERPOLATE</TD><TD>4,00</TD><TD>LR12345</TD></TR><TR><TD>055</TD><TD>22491,0</TD><TD>HOURS</TD><TD>2019-12-01</TD><TD>INTERPOLATE</TD><TD>4,00</TD><TD>LR12345</TD></TR></TBODY></TABLE> Wed, 27 Apr 2022 13:26:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Asset-Life-Cycle-Prediction-Date/m-p/2480604#M67872 JOSEAFC 2022-04-27T13:26:23Z Re: Asset Life Cycle Prediction Date https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Asset-Life-Cycle-Prediction-Date/m-p/2488128#M68388 <P><FONT>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="364821" data-lia-user-login="JOSEAFC" class="lia-mention lia-mention-user">JOSEAFC</a></FONT>&nbsp;</P> <P>Thanks for reaching out to us.</P> <P>Just want to confirm, is there a formula to calculate the <SPAN>Estimated Lifecycle Achievement</SPAN>, or do you want to know the principle of calculating it?</P> <P>&nbsp;</P> <P style="background: white;"><SPAN>Best Regards,</SPAN></P> <P style="background: white; box-sizing: border-box; font-variant-ligatures: normal; font-variant-caps: normal; orphans: 2; text-align: start; widows: 2; text-decoration-style: initial; text-decoration-color: initial; word-spacing: 0px;"><SPAN>Community Support Team _Tang</SPAN></P> <P style="background: white; box-sizing: border-box; font-variant-ligatures: normal; font-variant-caps: normal; orphans: 2; text-align: start; widows: 2; text-decoration-style: initial; text-decoration-color: initial; word-spacing: 0px;"><SPAN>If this post&nbsp;<STRONG>helps</STRONG>, please consider&nbsp;<EM><STRONG>Accept it as the solution</STRONG></EM>&nbsp;to help the other members find it more quickly.</SPAN></P> Mon, 02 May 2022 08:01:39 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Asset-Life-Cycle-Prediction-Date/m-p/2488128#M68388 v-xiaotang 2022-05-02T08:01:39Z Re: Asset Life Cycle Prediction Date https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Asset-Life-Cycle-Prediction-Date/m-p/2488608#M68419 <P>Hello!</P><P>&nbsp;</P><P>I'd like some tips on building it. I'm new on Power BI and I'm suffering on advanced formulas.</P><P>&nbsp;</P> Mon, 02 May 2022 12:16:38 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Asset-Life-Cycle-Prediction-Date/m-p/2488608#M68419 JOSEAFC 2022-05-02T12:16:38Z