Hi, My first post looking for help
Im following the training video on how to input ranking for workdays yet i get an error of a A circular dependency was detected: Dates[Column].
This is the code i added to a column in the table. Whats even more annoying i got it working the first time i did it however i didnt save my model and now when i try and do it again i get this error how do i fix it?
Workday Number = VAR CurrentMonth = Dates[Month & Year] VAR MonthTable = FILTER( ALL( Dates ), Dates[Day Type] = "Workday" && Dates[Month & Year] = CurrentMonth ) RETURN IF( Dates[Day Type] = "Weekend", BLANK(), RANKX( MonthTable, CALCULATE( AVERAGE( Dates[DayOfMonth] ) ), , ASC ))