Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
This is my current formula:
WorkingDays = IF (OR (DateDimension[DayOfWeek] = 7, DateDimension[DayOfWeek] = 1), 0, if(DateDimension[Date] = value("01/01/2016"),0,if(DateDimension[Date] = value("03/25/2016"),0,if(DateDimension[Date] = value("05/30/2016"),0,if(DateDimension[Date] = value("07/04/2016"),0,if(DateDimension[Date] = value("09/05/2016"),0,if(DateDimension[Date] = value("11/24/2016"),0,if(DateDimension[Date] = value("11/25/2016"),0,if(DateDimension[Date] = value("12/23/2016"),0,if(DateDimension[Date] = value("12/26/2016"),0,if(DateDimension[Date] = value("12/30/2016"),0,1)))))))))))
I of course hate this for obvious reasons. I have a holiday and a datedimension table.
The holiday table has the holidays in it so I think I need to use the RelatedTable function somehow. Any suggestions?
Thanks for your help.
Solved! Go to Solution.
Perhaps you could consider doing a Merge query in the query editor with the appropriate join (left anti?) to essentially filter out your holidays from your DateDimension table?
Perhaps you could consider doing a Merge query in the query editor with the appropriate join (left anti?) to essentially filter out your holidays from your DateDimension table?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |