Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Anonymous well if you need both column I mentioned that you use same IsHoliday logic in IsWorkingDay instead of using IsHoliday column in IsWorkignDay?

 

Did you tried this? Let's focus on this if this get solved then talk on next steps. I like to break things into smaller pieces.

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

parry2k 

Yes, I tried copying the formula of IsHoliday into IsWorkingDay and it still gave me the error.

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    7 years ago

    Anonymous 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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      parry2k 

      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.