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