Forum Discussion
Circular dependency.....why???
Your calendar table is derived from your fact table. That is akin to using CALENDARAUTO, and is Very Bad Indeed.
Overcome the urge to create calendar scripts in DAX or Power Query. They are useless. Use an external reference table.
You also don't need to specify table names in calculated columns.
Yeah, weird. You can avoid it by re-implementing the calculation rather than referencing it.
You mean like putting the initial calculation in a VAR lbendlin ?
Tried it (also changed my initial calculation but still no luck) but also does not work:
So I now made a column WeekendCorrection which returns 0 or 48.
But as you can see it still sees a circular dependency and I have no clue why....
Also why is it naming SC2[HourDiff]? That field is not involved in these calculations.
var _HourDiff is and not the original [HourDiff].
Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.