Forum Discussion
Convert Excel function to DAX - Power BI (Circular Reference Error)
Hey, I believe the data set has self referencing columns rather than recursive functions.
I identified the problem incorrectly.
Anonymous v-sihou-msft I've read other community forum posts where you've addressed a similar issue. Could you take a look at this data set too, you might be able to come up with something.
I open to everything from DAX solutions, to Power Query solutions, or even creative ways to restrcuture the data.
Please do give it a go, you'd be doing me huge favour!
Hi csinha,
For the circular reference issue, you can take a look at the following in to know more about this:
Avoiding circular dependency errors in DAX
BTW, current power bi reservation calculation can only achieve on the rolling calculations. (apply rolling calculations based on specific index filed and aggregate functions)
AFAIK, power bi data model table does not exist row/column index. If you want to invoke previous calculations, you need to manually/hard code to config correspond filters to get specific row calculations to result and it will increase on each iteration. (it same as Greg_Deckler 's link mentioned)
Regards,
Xiaoxin Sheng