Forum Discussion

HJK's avatar
HJK
Frequent Visitor
3 years ago

Can Power BI allow circular references?

Hi

 

Can Power BI allow circular references?

Like Excel

 

 

 
Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    HJK , I doubt that, But need context.

     

    But formula like this  not supported 

     

    B2 = B1+ A1

    B3= B2+A2

     

    The information you have provided is not making the problem clear to me. Can you please explain with an example.

    Appreciate your Kudos.

    • HJK's avatar
      HJK
      Frequent Visitor
      3 years ago

      Thank you for your reply.

       

      This is a circular referencing Excel example.
      This is a sample of costing by rolling up the BOM.
      The purchased sub-item E goes into D, and D and C go into B.
      Finally, B goes into A.
      At this time, the same column F is referenced, but a circular reference error occurs in POWER BI.

      No error occurs in Excel.

      (check the excel formula)
      I want to implement this in Power BI.
      How can I do it?

       

       

       

      https://1drv.ms/x/s!AkdnitUw_Bk2gtZ-28gpeLo3q4LRoQ?e=Qg5TsM