https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Compare-data-from-different-dates-in-the-same-table/m-p/996119#M12493 <P>Hi everyone,</P><P>&nbsp;</P><P>I have a data base that updates everyday with new information and I would like to bring the data from the previous day to a new calculated column to be compare with the data from today. Here's a example for better explanation:</P><P>&nbsp;</P><P><img /></P><P>I have that idea, but maybe there's a better solution for this problem, also I would like to create a matrix with the items in the row section, the 2 dates as columns and other column with the delta of the values. Hope anyone can help, thanks!</P><P>&nbsp;</P> Fri, 27 Mar 2020 21:38:01 GMT Anonymous 2020-03-27T21:38:01Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Compare-data-from-different-dates-in-the-same-table/m-p/996119#M12493 <P>Hi everyone,</P><P>&nbsp;</P><P>I have a data base that updates everyday with new information and I would like to bring the data from the previous day to a new calculated column to be compare with the data from today. Here's a example for better explanation:</P><P>&nbsp;</P><P><img /></P><P>I have that idea, but maybe there's a better solution for this problem, also I would like to create a matrix with the items in the row section, the 2 dates as columns and other column with the delta of the values. Hope anyone can help, thanks!</P><P>&nbsp;</P> Fri, 27 Mar 2020 21:38:01 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Compare-data-from-different-dates-in-the-same-table/m-p/996119#M12493 Anonymous 2020-03-27T21:38:01Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Compare-data-from-different-dates-in-the-same-table/m-p/996247#M12500 <P>See my article on Mean Time Between Failure (MTBF) which uses EARLIER: <A href="http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/339586" target="_blank">http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/339586</A></P> Sat, 28 Mar 2020 02:36:00 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Compare-data-from-different-dates-in-the-same-table/m-p/996247#M12500 Greg_Deckler 2020-03-28T02:36:00Z