Forum Discussion
Solved
get previous values per group
Hello everybody, I would like to have the previous values (see screenshot) displayed for the "ChangeWeek" column. So there should be a new column (see screenshot "new"), where the previous value p...
Try , as new columns
Column = maxx(filter('Table','Table'[ISIN]=EARLIER('Table'[ISIN]) && not(ISBLANK('Table'[ChangeWeek])) && 'Table'[Date]<EARLIER('Table'[Date])),'Table'[Date]) Column 2 = if(ISBLANK('Table'[ChangeWeek]),BLANK(),maxx(FILTER('Table','Table'[ISIN]=EARLIER('Table'[ISIN]) && ('Table'[Date])=EARLIER('Table'[Column])),('Table'[ChangeWeek])))
So generally you are going to do this with something like EARLIER - 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. What is the measure calculation that fixed it? Should be very translatable to a column.