The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I'm attempting to calculate the number of working days for each Employee, however I'm running into an issue when attempting to calculate it.
Using the supplied function below, I use this to calculate the number of
(StartDate as date, EndDate as date) as number =>
let
DateList = List.Dates(StartDate, Number.From(EndDate - StartDate), #duration(1, 0, 0, 0)),
RemoveWeekends = List.Select(DateList, each Date.DayOfWeek(_, Day.Monday) < 5),
RemoveHolidays = List.RemoveItems(RemoveWeekends),
CountDays = List.Count(RemoveHolidays)
in
CountDays
I then invoke a Custom Function selecting my BeginDate column and EndDate column
However it's giving me all Errors in the NWD column and saying this error message below. What am I doing wrong here, there's something I'm missing that's causing this.
Expression.Error: We cannot convert the value #datetime(2013, 5, 7, 22, 0, 0) to type Date.
Details:
Value=5/7/2013 10:00:00 PM
Type=[Type]
Solved! Go to Solution.
@LyonsBI_BRL
The Function NWD asks for Date, not Date/Time value. Before invoking the function, Under Transform Tab, Date > Click on Date Only to convert to Date
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@LyonsBI_BRL
The Function NWD asks for Date, not Date/Time value. Before invoking the function, Under Transform Tab, Date > Click on Date Only to convert to Date
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
That did it thank you!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
94 | |
93 | |
88 | |
70 | |
65 |
User | Count |
---|---|
231 | |
127 | |
117 | |
82 | |
82 |