Problem with Recursive Measure Calculation in Power BI

[Anonymous]

Guys,

I have the following problem.

I want to create a measure which calculates recursively the Value in "Stock calc" for future Monthes.

I just want to use the recursion formula:

Means, the measure should start by "2019 10".

STOCK.calc(2019 10) = STOCK (2019 10) + ExF(2019 10) - MS(2019 10)

STOCK.calc(2019 10) = 3649583.44 + 1408216.97 - 1521481.47

STOCK.calc(2019 10) = 3536319.95

For "2019 11":

STOCK.calc(2019 11) = STOCK.calc(2019 10) + ExF(2019 11) - MS(2019 11)

STOCK.calc(2019 11) = 3536319.95 +1636859.23 - 1400293.85

etc.

Can anyone help me please to solve this problem using DAX in Power BI?

[v-jayw-msft]

Hi @Anonymous ,

In my opinion, these two measures have interdependence with each other, which is not supported in Power BI.

You can do it in Excel.

Regards,

Jay