Power query % help

[lokou90]

Good morning,

I am writing to you because I am completely blocked ! I have an array with formulas in Power Query ! The principle is simple :

Get the difference between "cash buy (achat comptant)" and "cash sell(vente comptant)" values ! There is a file in history and a graph.

I would like to add columns, like the following ↓ ;

- A column with the percentage of gain or loss.

- A column with the number of days elapsed or hours if it is less than one day since the purchase and resale.

- A column that calculates me the profit made in the day between the date of purchase and resale.

As in this picture ↓

there may be multiple purchase/resale movements for the same value and at the same date. If a value is purchased, it is not required to be sold yet.


The four columns does not work very well it seems to me ! I can't seem to load with more than 200 lines

Files exemples

I can't put the formulas back in Power Query, if someone can kindly help me, it would be really great !!!

 

[sandy666]

as I said this is not my language
if you want more info about Power Query read this

Documentation Power Query - Power Query

Power Query est utilisé pour filtrer, combiner, et fusionner des données à partir d’une ou plusieurs sources de données prises en charge.

docs.microsoft.com

 

[lokou90]

I am unable to fix this problem, it is the FIFO it seems to me... (First In First Out). Is anyone here able to understand my problem ? ????