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 acco...
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

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)