Hi community,Im trying to calculate ProjectedStock, but I'm facing a recursive issue :in the period or the same period as the extraction (for example 202508==period of extracted data is 22/08/2025) :projectedstock = [V1]+[V2]+Stock_At_Time-[V3+V4].Till here everything is ok, the problem appears in the calculation of the ProjectedStock for the next periods because the Stock_At_Time should be taken as the ProjectedStock[Period-1]:for example :ProjStock(202511) = [V1]+[V2]+ProjectedStock[202510]-[V3+V4].andProjStock(202510) = [V1]+[V2]+ProjectedStock[202509]-[V3+V4].andProjStock(202509) = [V1]+[V2]+ProjectedStock[202508]-[V3+V4].So, how to do so without having a circular dependencies or recursive issues.Thank you.

Thankyou, bhanu_gautam, danextian, Shahid12523 and AmiraBedh for your responses.Hi PBIDev01, We appreciate your inquiry submitted through the Microsoft Fabric Community Forum. Based on my understanding of the scenario, please find attached a screenshot and a sample PBIX file which may assist in resolving the issue: We hope the information provided proves helpful. Should you have any further queries, please feel free to contact the Microsoft Fabric Community. Thank you.

measure for recursive approach | Microsoft Fabric Community

Forum Discussion

Related content

Blank columns when doing Measure Name Measure Value approach

Recursion Strategy

Recursive Calculation and Forecast measure

Recursive loop Measure /Auto Adjustable Measure /Circular Dependency Issue While Adjusting values

Duplicate Table best approach