Forum Discussion
Post PatronIssues Migrating Existing Dashboard to On-Premises Version (January 2026)
Hi F_Reh ,
The DAX formula itself looks valid and Date is correctly generated by the CALENDAR() function.
A circular dependency usually occurs when another table references a calculated column from the Date table and that column is used in a relationship back to the Date table.
Please review the model relationships and check whether any relationships use calculated columns such as DateAsInteger, YearMonthNumber, or similar. If so, try changing the relationship to use the base DatesTable[Date] column instead.
Additionally, I noticed a small typo in the ContractYear calculation (FORMAT([DATE],"YYYY") should be FORMAT([Date],"YYYY")). While this may not be the root cause, correcting it would be recommended.
If the issue persists, please share a screenshot of the model relationships or confirm whether any calculated columns in other tables reference the DatesTable.
Best Regards,
Chaithra E.
Post Patron@Model View showing only one table:
I simply Zoomed out, and found the other tables (in spite of the Circular Dependency error still showing):
The Dates Table formula is as follows – and is exactly the same as is used in my other dashboards (where it works fine without any Circular Dependency issue). Actually, I am unable to see any foreign columns from other tables that could be causing the issue:
DatesTable =
ADDCOLUMNS (
CALENDAR (DATE(2019,4,1),TODAY()),
"DateAsInteger" ,FORMAT ( [Date], "YYYYMMDD" ),
"Year" ,YEAR ( [Date] ),
"Monthnumber", FORMAT ( [Date], "MM" ),
"YearMonthnumber", FORMAT ( [Date], "YYYY/MM" ),
"YearMonthShort", FORMAT ( [Date], "YYYY/mmm" ),
"MonthNameShort", FORMAT ( [Date], "mmm" ),
"MonthNameLong", FORMAT ( [Date], "mmmm" ),
"DayOfWeekNumber", WEEKDAY ( [Date] ),
"DayOfWeek", FORMAT ( [Date], "dddd" ),
"DayOfWeekShort", FORMAT ( [Date], "ddd" ),
"Quarter", "Q" & FORMAT ( [Date], "Q" ),
"YearQuarter", FORMAT ( [Date], "YYYY" ) & "/Q" & FORMAT ( [Date], "Q" ),
"FiscalMonthNumber",IF ( MONTH([Date]) > 3, MONTH([Date]), MONTH([Date])+12 ),
"ContractYear", IF ( MONTH([Date]) <= 3,
FORMAT([Date],"YYYY")-1 &"-"& FORMAT([Date],"YYYY"),
FORMAT([Date],"YYYY") &"-"& FORMAT([DATE],"YYYY")+1
),
"IsCurrentMonth", IF(YEAR([Date]) = YEAR(TODAY())
&& MONTH ( [Date]) = MONTH (TODAY())
,"Yes"
,"No"
),
"FiscalYear" , SWITCH(
TRUE(),
YEAR([Date]) = YEAR(TODAY())
&& MONTH ([Date]) <= 3,0,
YEAR([Date]) = YEAR(TODAY()) - 1
&& MONTH ([Date]) > 3,0,
YEAR([Date]) = YEAR(TODAY())
&& MONTH ([Date]) > 3,1,
YEAR([Date]) = YEAR(TODAY()) +1
&& MONTH ([Date]) <= 3,1
),
"Current Month" , FORMAT(TODAY() , "mmmm"),
"Week Start Date",[Date] - WEEKDAY([Date],1)+1,
"Week End Date",[Date] - WEEKDAY([Date],2)+7,
"MonthYearShort", FORMAT ( [Date], "mmm-YY" ))
I assume [Date] is "supposed" to be created by CALENDAR (DATE(2019,4,1),TODAY()).
v-echaithraCommunity Support
Hi F_Reh ,
The DAX formula itself looks valid and Date is correctly generated by the CALENDAR() function.
A circular dependency usually occurs when another table references a calculated column from the Date table and that column is used in a relationship back to the Date table.
Please review the model relationships and check whether any relationships use calculated columns such as DateAsInteger, YearMonthNumber, or similar. If so, try changing the relationship to use the base DatesTable[Date] column instead.
Additionally, I noticed a small typo in the ContractYear calculation (FORMAT([DATE],"YYYY") should be FORMAT([Date],"YYYY")). While this may not be the root cause, correcting it would be recommended.
If the issue persists, please share a screenshot of the model relationships or confirm whether any calculated columns in other tables reference the DatesTable.
Best Regards,
Chaithra E.