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.
lbendlinoohhh now I see what changed in your version :
This was :
You started at February so it could not see a weekend marker for January data so that is why your measure did show 0 for weekend in January.
But the determination of the max and min date than are the cause of the circular dependancy?
That would be strange.
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 ?