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.
Hi power bi experts!! I am having a circular reference error while trying to calculare SPI and CPI coloumn. SPI =Cumulative BCWP/Cumulative BCWS. I have figured out that the cumulative BCWP is the source of the problem. I just can not fix the circular referecne error. It will be great if you can fix the issue. I have attached the file here: https://drive.google.com/file/d/0B0XwYvmbIN12cktTaHZpTi1IZTQ/view?usp=sharing
A promp solution will be relaly helpful. Thank you.
Regards
Hasan
Solved! Go to Solution.
Hi @Hasan_iba,
Based on my research, there are normally two ways to solve the circular dependency issue:
For more details about the circular dependency issue, you can refer to this article.
In addition, after looking into your shared pbix file, I would suggest you try using Merge Queries options in Query Editor to merge your "TaskTimephasedDataSet" table and "TaskBaselineTimephasedDataSet" table into a single table, which should make your data mode clear and easier to handle. Here is an article about how to use Merge Queries option for your reference.
Regards
Hi @Hasan_iba,
Based on my research, there are normally two ways to solve the circular dependency issue:
For more details about the circular dependency issue, you can refer to this article.
In addition, after looking into your shared pbix file, I would suggest you try using Merge Queries options in Query Editor to merge your "TaskTimephasedDataSet" table and "TaskBaselineTimephasedDataSet" table into a single table, which should make your data mode clear and easier to handle. Here is an article about how to use Merge Queries option for your reference.
Regards
Hello Power BI community. I am getting circular reference error. I need to calculate SPI which is equal to cumulative BCWP/cumulative BCWS. I need to have SPI as a calculated column. I have figured out that the source of the circular reference is the cumulatiive BCWP column but cant figure out the problem of circular reference. The pbix file is in the link: https://drive.google.com/file/d/0B0XwYvmbIN12cktTaHZpTi1IZTQ/view?usp=sharing
A promp help will be much appreciated.
Thank you
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 |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |