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!
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi dghubbard06 ,

If your problem is solved, please mark the corresponding answer as a solution.

 

Best Regards