Forum Discussion
Problem with comparing row values in the same column
Hi ngulminelli ,
According to your description, my understanding is that you want to calculate the % paid between he last precio_unitario paid and the other precio_unitario that the same description was paid in the pass. In another word, it is precio_unitario of the latest fecha / precio_unitario of other rows in the same Descripcion.
We can use the following DAX query:
Measure = var thelastone = CALCULATE(MIN(Table1[precio_unitario]),FILTER(ALL(Table1),Table1[fecha] = MAX(Table1[fecha]))) return DIVIDE(thelastone,SUM(Table1[precio_unitario]) - thelastone)
Best Regards,
Teige
Solution SageHi ngulminelli ,
According to your description, my understanding is that you want to calculate the % paid between he last precio_unitario paid and the other precio_unitario that the same description was paid in the pass. In another word, it is precio_unitario of the latest fecha / precio_unitario of other rows in the same Descripcion.
We can use the following DAX query:
Measure = var thelastone = CALCULATE(MIN(Table1[precio_unitario]),FILTER(ALL(Table1),Table1[fecha] = MAX(Table1[fecha]))) return DIVIDE(thelastone,SUM(Table1[precio_unitario]) - thelastone)
Best Regards,
Teige
Hi Teige that´s exactly wright, it worked fine! thank you very much!
Hi TeigeGao that solved part of my problem, but what I was really trying to solved is to calculate the % difference between price on index 1 from index 2, then from index 2 % difference from index 3, and so on....
is it posible? I managed to get the last price, but can figure out how to iterate....
Date Price Index 01-04-19 00:00 $2,493.20 1 22-03-19 00:00 $2,363.76 2 14-02-19 00:00 $2,200.55 3 30-01-19 00:00 $2,172.41 4 14-01-19 00:00 $2,127.38 5 07-01-19 00:00 $2,155.52 6 23-11-18 00:00 $2,104.87 7 07-11-18 00:00 $2,048.59 8 19-10-18 00:00 $2,110.50 9 08-10-18 00:00 $2,178.04 10 17-09-18 00:00 $2,273.71 11 22-08-18 00:00 $1,029.92 12