Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Get previous row value in new column

Hi,   I have seen all the solutions related to this topic and couldn't find a solution to my problem hence posting here.  I have created a new table in power bi using summarize which is just a coun...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    Sample data would help but perhaps something like:

     

    Previous = 
var PreviousDate = MAXX(FILTER(ALL(ddd),EARLIER(ddd[Date]) > ddd[Date] ),ddd[Date])

Return CALCULATE(MAX(ddd[NewUsers]),FILTER(ddd,ddd[Date] = PreviousDate))
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

Sample data would help but perhaps something like:

 

Previous = 
var PreviousDate = MAXX(FILTER(ALL(ddd),EARLIER(ddd[Date]) > ddd[Date] ),ddd[Date])

Return CALCULATE(MAX(ddd[NewUsers]),FILTER(ddd,ddd[Date] = PreviousDate))
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks.  works now!  I was close but didn't get what was missing from mine one.  I have used MAX instead of MAXX and not used FILTER explicitly in return...

 

Previous = var PreviousDate = CALCULATE(MAX(ddd[Date]),FILTER(ddd,EARLIER(ddd[Date]) > ddd[Date] ))

Return CALCULATE(MAX(ddd[NewUsers]),ddd[Date] = PreviousDate)