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 =
//Inntekter
VAR 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.