Forum Discussion
Calculation without relation to date filters
Hi, I have a problem. I'm tryin to calcutate the profitof a certain product. This containt two calculations; - Revenue carparts - Cost carparts Both of these calculations come from the sam...
andhiii079845
Solution Sage
Solution SageI try to understand the problem. Do you mean that you filter a period of time, items in this time frame generate cost and revenue but the items were bought before. ? Sorry i did not understand it. Can you show a good example and also your underlaying data?
Hi!
The calculation that shows revenue carparts is as follows;
Salg deler =//InntekterVAR P1 = CALCULATE(SUM(hovedbok[Amount]),Filter(Hovedbok,Hovedbok[AccountNo]=3001))Var P2 = CALCULATE(SUM(Hovedbok[Amount]),FILTER(Hovedbok,Hovedbok[AccountNo]=3004))Return-(P1)-(P2)The calculation that shows cost carparts is as above.I have serveral slicers, years and months as shown above in the picture.The problem is that I want to show the profit on these projects over a period selected from the slicer. That means that i want to show the revenue carparts, for example january 2023. But when i choose that period I also get the cost from january 2023 aswell, and the cost may originate from for example desember 2022. That means that the cost-calcuted has to be independent from the slicer.In our business we order the carparts serveral periods before we invoice the part.
