Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to Solution.
@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
I have a similar situation, I need cumulative Sum, but I get a circular dependency error when I create a calculated column
Hi ,
Can you help me on my solution i need somthing like this only diffrence is when i filter i want to show all the values cummilative
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |