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))
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thanks.. I visited the link and I get your point on getting the Max previous date first and then fetching corresponding value but how to do that in a single DAX formula, still struggling.  If you can help.. I tried something like below but it gave all blank values.

     

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

    Return CALCULATE(FIRSTNONBLANK(ddd[NewUsers],""),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)