topic Re: Calculate working days from today() in a column in DAX Commands and Tips

Calculate working days from today() in a column

ScottCC — Wed, 01 Feb 2023 11:46:44 GMT

Hi all, new to the forum and to PBI too! Ive checked the archives but cant find an answer to the following....

I am trying to figure out how I can add a column to an existing table that will show me the number of working days (Networkdays?) between today and the date in another column.

Is it as simple as using Newtworkdays and adding a VAR for today()?? I assuming not but thought I would ask the community!!

Any help is greatly appreciated

Re: Calculate working days from today() in a column

Payeras_BI — Wed, 01 Feb 2023 12:44:59 GMT

Hi ScottCC,
It works just like this.

Re: Calculate working days from today() in a column

FreemanZ — Wed, 01 Feb 2023 13:06:57 GMT

hi ScottCC

if you expects a calculated column, try like:

Column = NETWORKDAYS([Date], TODAY())

NETWORKDAYS accepts additional holiday arguments, if you have a list of holidays as a table.

https://dax.guide/networkdays/

Re: Calculate working days from today() in a column

ScottCC — Thu, 02 Feb 2023 09:27:08 GMT

This worked perfectly for what I needed, clearly I was overcomplicating things!!! Thank you

Re: Calculate working days from today() in a column

ScottCC — Thu, 02 Feb 2023 09:30:09 GMT

Hi, Thanks for this. It worked, partly. For some reason for a small data set it worked exactly as expected.... but whn the same was applied to a larger set it gave the same return, irrespective of the table column dates. Strange one I just couldnt understand at all, despite the dates being all different the return came bac all as 33211. But it really helped in my understanding so thank you