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.
Hello Community,
I have a question about wokring days.
Before you send me links here, i read it and thats why i post this question.
I read the page of Alberto Ferrari : http://sqlblog.com/blogs/alberto_ferrari/archive/2011/01/19/working-days-computation-in-powerpivot.a...
After that, I create a calendar and an another table with all holidays here :
Jour Férié (France) | Annee | Jour semaine | Jour | DateComplète | Mois | Date |
Jour de l'an | 2018 | 0 | Lundi | lundi 1 janvier 2018 | Janvier | 1 janvier 2018 |
Pâques | 2018 | 6 | Dimanche | dimanche 12 avril 2020 | Avril | 12 avril 2020 |
Lundi de Pâques | 2018 | 0 | Lundi | lundi 13 avril 2020 | Avril | 13 avril 2020 |
Fête du Travail | 2018 | 1 | Vendredi | vendredi 1 mai 2020 | Mai | 1 mai 2020 |
Armistice 1945 | 2018 | 1 | Vendredi | vendredi 8 mai 2020 | Mai | 8 mai 2020 |
I make realtion between my calendar and my holidays table, and its working.
I begin with the Excel Working Days : and it doesnt works .
IF (OR ([@WeekDay] = 6, [@WeekDay] = 7), 0, IF (ISNA (VLOOKUP ([@Date], HolidaysTable[#Data], 2, FALSE)), 1, 0))
The first part is working : IF (OR ([@WeekDay] = 6, [@WeekDay] = 7), 0, 1) I have the good result. But how can i check in my jours fériés table if the date are present and if its the case then it's not a working days.
Thank you in advance
Solved! Go to Solution.
You may use WEEKDAY Function and CONTAINS Function in DAX.
You may use WEEKDAY Function and CONTAINS Function in DAX.
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |