Forum Discussion
Anonymous
6 years agoNot applicable
Compare data from different dates in the same table
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!
1 Reply
- Greg_DecklerCommunity Champion
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/339586