Forum Discussion
Need help with Circular Dependency Workaround
Hi, not very sure about the data what you have in the excel and in the main table, however looking into the details it seems you are first deriving the 1st screenshot in dax and then trying to do the 2nd one. You can do one thing, 1st step try to achieve using power query. In that way, there will not be any circular dependency.
If this helps to resolve your problem, then please mark it as solution, thanks
Super UserPlease include, in a usable format, not an image, a small set of rows for each of the tables involved in your request and show the data model in a picture, so that we can import the tables in Power BI and reproduce the data model. The subset of rows you provide, even is just a subset of the original tables, must cover your issue or question completely. Alternatively, you can share your .pbix via some cloud service and paste the link here. Do not include sensitive information and do not include anything that is unrelated to the issue or question. Please show the expected outcome based on the sample data you provided and make sure, in case you show a Power BI visual, to clarify the columns used in the grouping sections of the visual.
Need help uploading data? click here
Want faster answers? click here
Hello FBergamaschi, I have included a table with a small sample of my data as well as expected results. The first 2 columns are static data. Column 3 is calculated based on the date diff between the current and previous row. Columns 5 - 7 are calculated as well and the final column includes my expected result. Thanks again and let me know if there is anything else I can do to help specify.
