calculation in power bi

[woshi_eads]

Dear,

How to achieve the result like that

category	Month number	value	result	result formula
Actual & Forecast Cost	7
Actual & Forecast Cost	2		144.7975	=C8*C16/C17
Actual & Forecast Cost	3		185.2036	=E3*C17/C18
Actual & Forecast Cost	4		166.8426	=E4*C18/C19
Actual & Forecast Cost	5			=E5*C19/C20
Actual & Forecast Cost	6			…..
Actual & Forecast Cost	1	146
Actual & Forecast Cost	8
Actual & Forecast Cost	9
Actual & Forecast Cost	10
Actual & Forecast Cost	11
Actual & Forecast Cost	12
Commercial sales 1+11	1	71426
Commercial sales 1+11	2	73758
Commercial sales 1+11	3	85611
Commercial sales 1+11	4	86322
Commercial sales 1+11	5	67489
Commercial sales 1+11	6	78964
Commercial sales 1+11	7	87654
Commercial sales 1+11	8	98765
Commercial sales 1+11	9
Commercial sales 1+11	10
Commercial sales 1+11	11
Commercial sales 1+11	12

[ChainsawMan]

@woshi_eads  Have you resolved this problem? I also want to achieve something like this.

[Anonymous]

HI @woshi_eads,

According to the snapshot, it seems like you want to achieve recursive calculations.  AFAIK, current power bi Dax formula does not support these calculations.

You can also take a look at the Greg’s the blog about research in Dax recursive if helps:

Previous Value (“Recursion”) in DAX – Greg Deckler

Regards,

Xiaoxin Sheng