Desktop

[husss]

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.

MagazaKodu	FaturaSaati	FaturaSayisi	Previous Value
3004	9	26
3004	10	1167	26
3004	11	2113	1167
3004	12	2970	2970
3004	13	3388	3388
3004	14	3801	3801
3004	15	4204	4204
3004	16	4561	4561

[v-yuezhe-msft · Accepted solution]

@husss,

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

[v-yuezhe-msft · Accepted solution]

@husss,

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

[husss]

Hi @v-yuezhe-msft,

Thanks a lot. It helped me.

Best regards..