Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

DAX getting previous value

Hi there, 

 

I have a table like that:

 

What I want to do is, getting the previous row value as shown below. There are multiple "MagazaKodu" and "FaturaSaati". I want to get previous values according to both "MagazaKodu" and "FaturaSaati". How can I handle this? I have tried "EARLIER" function but it did not work.

 

MagazaKoduFaturaSaatiFaturaSayisiPrevious Value
3004926 
300410116726
30041121131167
30041229702970
30041333883388
30041438013801
30041542044204
30041645614561

 

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous,

    Create a caclulated column using DAX below.

    previous value = CALCULATE(FIRSTNONBLANK(Table1[FaturaSayisi],1),FILTER(Table1,Table1[MagazaKodu]=EARLIER(Table1[MagazaKodu])&&Table1[FaturaSaati]=EARLIER(Table1[FaturaSaati])-1))



    Regards,
    Lydia

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Anonymous,

    Create a caclulated column using DAX below.

    previous value = CALCULATE(FIRSTNONBLANK(Table1[FaturaSayisi],1),FILTER(Table1,Table1[MagazaKodu]=EARLIER(Table1[MagazaKodu])&&Table1[FaturaSaati]=EARLIER(Table1[FaturaSaati])-1))



    Regards,
    Lydia

    • WMM's avatar
      WMM
      Regular Visitor
      1 year ago

      Very handy, Lydia Anonymous ! Thanks for sharing!
      By the way, in my case I used it to calculate the previous date value, replacing

      Table1[FaturaSaati]=EARLIER(Table1[FaturaSaati])-1)

      by

      Table1[Date]=EARLIER(Table1[Date])-1)
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous,

     

    Thanks a lot. It helped me.

     

    Best regards.. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi ,

    Can you help me on my solution i need somthing like this only diffrence is when i filter i want to show all the values cummilative 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I have a similar situation, I need cumulative Sum, but I get a circular dependency error when I create a calculated column