Forum Discussion
jeyare
Helper II
Helper IIIncrement of previous date value
Hi, can't find a solution for callculation of increments based on few conditions. Current table example in my Power Query: date person performance 4.4.2020 A 10 4.4.2020 B 12 ...
So basically, as in the article referenced, something like:
Increment Column = VAR __Current = [performance] VAR __PreviousDate = MAXX(FILTER('Table',[person] = EARLIER([person]) && [date] < EARLIER([date])),[date]) VAR __Previous = MAXX(FILTER('Table',[person] = EARLIER([person]) && [date] = __PreviousDate),[performance]) RETURN __Current - __Previous
Greg_Deckler
Community Champion
Community ChampionHmm, see attached PBIX. Can't say what went wrong but the PBIX seems to work fine.
jeyareHelper II
Helper IIthx Greg_Deckler , my fault
- Greg_DecklerNo worries! Glad we got it solved! 🙂