Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Circular Dependency

Hello,

 

I have monthly rolling forecast for all subsidairies. Raw data (Column A~E) is like following. G3, H3 & I3 were calculated by other formulas. Please advise how to calculate rest cells for Column G~I. I have more than one Product and Subsidiaries.

 

Thank you.

 

Need Help

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    This is only possible in Power Query with List.Accumulate.

     

    Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

    Do not include sensitive information or anything not related to the issue or question.

    If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

    Please show the expected outcome based on the sample data you provided.

    Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi. Below is the sample data. Please advise how to solve it in Power Query. Thank you very much

      ProductCompanyMonthForecast DueThis month ForecastPrevious Month ForecastM0 C/FM0 RemAfter M0 FC
      Car 1AAAMonth 011/1/20242    
      Car 1AAAMonth 012/1/202412100
      Car 1AAAMonth 021/1/20242    
      Car 1AAAMonth 022/1/2024120 =IF(E5>=H3,H3,E5)0 =H3-G51 = E5-G5
      Car 1AAAMonth 031/1/20242    
      Car 1AAAMonth 032/1/2024720 =IF(E7>=H5,H5,E7)0 =H5-G77 = E7-G7
      Car 1AAAMonth 041/1/20241    
      Car 1AAAMonth 042/1/2024110 =IF(E9>=H7,H7,E9)0 =H7-G91 =E9-G9
      Car 1AAAMonth 051/1/20241    
      Car 1AAAMonth 052/1/202411001
      Car 1AAAMonth 061/1/20241    
      Car 1AAAMonth 062/1/202411001
      Car 1AAAMonth 071/1/202412    
      Car 1AAAMonth 072/1/2024412004
      Car 1AAAMonth 081/1/20243    
      Car 1AAAMonth 082/1/202433003
      Car 1AAAMonth 091/1/20243    
      Car 1AAAMonth 092/1/202443004
      Car 1AAAMonth 101/1/20241    
      Car 1AAAMonth 102/1/202401000
      Car 1AAAMonth 111/1/20240    
      Car 1AAAMonth 112/1/202400000
      Car 1AAAMonth 121/1/20240    
      Car 1AAAMonth 122/1/202400000
      Car 2BBBMonth 011/1/2024     
      Car 2BBBMonth 012/1/2024     
      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

        Why is H3   resulting in 0 and not in -1 ?