Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
HJK
Frequent Visitor

Can Power BI allow circular references?

Hi

 

Can Power BI allow circular references?

Like Excel

 

HJK_0-1670400353008.png

 

 
2 REPLIES 2
amitchandak
Super User
Super User

@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.

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?

 

HJK_1-1670461696052.png

 

 

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

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.