Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am having trouble with a circular reference in my measures.
I believe my biggest issue is with a circular reference between the Opening and the Forecast figure.
I have included a OneDrive link to an excel sheet, this is what I am trying to achieve in Power Bi.
I have also created a pbix file with some dummy data, and the OneDrive link is below:
OneDrive file for PBIX dummy data
I have simplified the measures I was trying to use as I think the main issue i have is the circular reference for the Opening measure as this is trying to use the forecast measure, but I can't think of a way around this as the forecast measure is based on the opening measure for the previous month.
These are my measures, it is the Opening measure that has the error:
Thank you in advance for any help!
That's not your only problem. Opening Figure also has a circular reference.
Do these have to be measures? If you calculate these values in Power Query you can avoid the circular references.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |