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 |
1 ACCEPTED SOLUTION
Accepted Solutions
@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,
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
Helpful resources
Challenge: Can You Solve These?
Find out how to participate in the first Power BI 'Can You Solve These?' challenge.
Microsoft Business Applications October Virtual Launch Event
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
Win Power BI Swag with Community Kudopalooza!
Each week, complete activities and be qualified in the drawing for cool Power BI Swag.
