Forum Discussion
Circular Dependency with Date Tables
Hi, I'm trying to create a couple calculated columns within a date table for use in other tables. Namely, I have an "IsWorkDay" column (boolean) and an "IsHoliday" column (boolean), which is calcula...
Anonymous attached. I added two columns in PowerQuery, feel free to change as per your need.
Yes, I tried copying the formula of IsHoliday into IsWorkingDay and it still gave me the error.
parry2k
Super User
Super UserAnonymous ok, I didn't looked at your file yet thou. I'm wondering why not you merge both tables in PowerQuery and then IsHoliday just part of date table.
- parry2k
Anonymous attached. I added two columns in PowerQuery, feel free to change as per your need.
If I merged them, how would that look? The holiday table is just a 2-column table with a few lines that show our company's holiday schedule, whereas my date table is a whole bunch of columns with month number, month name, quarter, etc.
I think that'll do it. Thanks for all the help!