Forum Discussion
Anonymous
7 years agoNot applicable
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...
- 7 years ago
Anonymous attached. I added two columns in PowerQuery, feel free to change as per your need.
Anonymous
7 years agoNot applicable
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.
parry2k
Super User
7 years agoAnonymous attached. I added two columns in PowerQuery, feel free to change as per your need.
- Anonymous7 years agoNot applicable
I think that'll do it. Thanks for all the help!