Compare data from different dates in the same table

[Anonymous]

Hi everyone,

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:

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!

[Greg_Deckler]

See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395...