Forum Discussion
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...
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!
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!
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!