Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Good day and good after noon teachers !!! 1 big hand with a calendar table please!... I need to make holidays "False" in the same column (Workdays)... as you see I have only weekends as False at the moment... any advice according with what I have? (I have to keep it like this with 2 columns "Date" and "Workdays") Thank you in advance community.
WorkDay =
VAR WeekDayNum =
WEEKDAY ( 'Calendar'[Date], 2 )
RETURN
(
IF ( WeekDayNum = 6 || WeekDayNum = 7,,FALSE(),TRUE() ))
Solved! Go to Solution.
You'll need a data source of holidays. These will vary from region to region, organisation to organisation. Once you have the list that is relevant for your reports, import it as a table. You can then merge the details into a new column in your Date table or extend the logic of your existing column.
Hi Phil... I did what you said and this look like this: I made a holiday table then, over my calendar table, I added the holiday column with a "Related column function" ...after that, I added another column with "IF" function as you see in the pic... I think it worked but Im not sure if that if what you meant.
Thanks in advance for your feedback.
You'll need a data source of holidays. These will vary from region to region, organisation to organisation. Once you have the list that is relevant for your reports, import it as a table. You can then merge the details into a new column in your Date table or extend the logic of your existing column.
Hi Phil... I did what you said and this look like this: I made a holiday table then, over my calendar table, I added the holiday column with a "Related column function" ...after that, I added another column with "IF" function as you see in the pic... I think it worked but Im not sure if that if what you meant.
Thanks in advance for your feedback.
It looks good. But do you want your new column to say True (when it's a weekend or holiday) and False (for everything else) ?
If so add this column
Is Workday = IF('Calendar'[Workday] || 'Calendar'[Workday (1)],FALSE(),TRUE())
Vice versa Phil... False when is weekend and holiday and as you can see is done...the logic is very simple ..it is what I needed. Thank you Phil to light my way to the solution!!!!
.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |