Forum Discussion

dghubbard06's avatar
dghubbard06
New Member
1 year ago
Solved

Unable to Execute Dax - Circular Dependency

Hello,   In the last month, I started to get an error message when opening the desktop app: In doing a bit of research on these forums, it appears it could be linked to a recent releas...
Need Help
  • dghubbard06's avatar
    dghubbard06
    1 year ago

    Thank you both, I was able to go in and update my query as:

    Master Calendar = ADDCOLUMNS(CALENDAR(
                            DATE(2019,01,01),
                            DATE(2025,12,31)),
                            "Year", YEAR([Date]),
                            "MonthNo", MONTH([Date]),
                            "Month", FORMAT([Date],"mmm"),
                            "Day", DAY([Date]))

    This workaround appears to be working for now, with some modifications to the formatting on existing reports. I may go back in and create a calendar table on PQ as Ritaf1983 suggested in the future, but right now I am under deadline. Thank you!
Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
1 year ago

Hi dghubbard06 

 


This is a known issue with the latest version of Desktop, which is already being addressed.

In the meantime, simply change the way you build the calendar table. Instead of using CALENDARAUTO, use the CALENDAR function.

Alternatively, you can build the calendar table in Power Query (PQ) instead of using DAX.

In any case, regardless of this issue, a calendar table built in Power Query will generally be more stable, as it's equivalent to bringing it directly from the data source.
Guide to calnder with dax :
https://blog.coupler.io/power-bi-date-table/#:~:text=Power%20BI%20date%20table%20using%20CALENDAR%20DAX%20functions

 

With PQ :
https://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns

 

the script is included 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.