search

sql-bi / DaxDateTemplate

Power BI template to create a Date table in DAX
MIT License
265 stars 76 forks source link

Add a Working Day Number for the month #34

Closed marcl1 closed 4 years ago

marcl1 commented 4 years ago

Hi,

based on the column "Day type" and on an internet feed https://community.powerbi.com/t5/Desktop/Calculate-the-current-business-day-number-in-the-month/m-p/561508#M264882 I've created the column Working Day Number

Would it be integrated directly in the table and programmed perfectly, it would be perfect ! thx in advance

marcosqlbi commented 4 years ago

The Working Day is already available in the column "IsWorkingDay" and it is populated according to the configuration you set in the table. Why do you need the working day number as a calculated column?

marcosqlbi commented 4 years ago

This section is public - please remove any sensitive data immediately thanks!

marcl1 commented 4 years ago

I’m working in a business where our sales and other activities are usually during the weekdays. As we compare usually the current year and the previous year, it would be good to compare WD1 of this year with the WD1 of previous year, and the same for the following days...

marcosqlbi commented 4 years ago

I suggest you creating a calculated column counting the working days before the current date to populate the column.