0
I ask it is possible to develop this account in power BI or Query, I already passed by other groups and I was told this, it seems simple but a kind of loop.
The first 4 columns are part of the base, the others I tried to calculate with measure or column calculated, but after calculating the cost of the sale and deducting this cost from the own accumulated cost value of column G, the formula is lost by not working row by row.
I’ll put the Power Bi link, I can’t even indicate where the error is.
Link https://drive.google.com/drive/folders/1F4X244y3NXB-hnM8rOuqE1UMLVU_3msC?usp=sharing