Forum Discussion
Difference between rows in relation to a single data
Hello Community, I need help calculating the difference between two rows (capital) associated with the same SAME RUT AND DOCUMENT. Each row shows an amount of capital associated with a correspond...
Syndicate_Admin , a new column
=
var _max = maxx(filter(Table, [document] = earlier([Document]) && [Date] < earlier([Date]) ), [Date] )
return
maxx(filter(Table, [document] = earlier([Document]) && [Date] =_max ), [captial] )
Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=17820s