Forum Discussion
Solved
Power Query Implementation
Hi, I have come across a process to count the hours between 2 dates, only counting working hours (https://addendanalytics.com/blog/calculate-working-hours-in-power-bi). When I try to implemen...
Matt_dev
There are two things to check.
Your question is in Power Query topics, and calculation in the blog is in DAX.
DAX is not used in Power Query (M script), but in data modelling part.
Regarding M scripts:
You must follow M query structure:M query needs to start with Let .. and end with In ...
However, the script from the blog is DAX query, not M script, so it should be in data modelling, not in Power Query.
Cheers,
Nemanja
