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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.