cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
husss Regular Visitor
Regular Visitor

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

 

aaa.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: DAX getting previous value

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

1.PNG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Moderator v-yuezhe-msft
Moderator

Re: DAX getting previous value

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

1.PNG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
husss Regular Visitor
Regular Visitor

Re: DAX getting previous value

Hi @v-yuezhe-msft,

 

Thanks a lot. It helped me.

 

Best regards..