Forum Discussion
Solved
Circular dependency.....why???
So I have this calculated column returning a nummber : HourDiff = VAR _StartDay = SC2[D1] VAR _EndDay = SC2[D2] VAR _Correction = IF(_EndDay = 1 && _StartDay < 6 && _StartDay <> 1, ...
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.
When two tables depend on each other you always get a circular dependency. Nothing strange here.
Well I did my MAX and MIN in the sample file and the weekends where good again and no circular in the sample file....
But now I saw this :
In the sample file the Timing calculated column has an fx sign.
In the original :
There is is a sigma sign....
So how did you get that fx sign in the sample file lbendlin ?