Reply
Regular Visitor
Posts: 27
Registered: ‎08-13-2018
Accepted Solution

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


Accepted Solutions
Moderator
Posts: 9,878
Registered: ‎03-10-2016

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.

View solution in original post


All Replies
Moderator
Posts: 9,878
Registered: ‎03-10-2016

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
Regular Visitor
Posts: 27
Registered: ‎08-13-2018

Re: DAX getting previous value

Hi @v-yuezhe-msft,

 

Thanks a lot. It helped me.

 

Best regards..