Calculate working days from today() in a column

[ScottCC]

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

[FreemanZ · Accepted solution]

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/

[ScottCC]

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

[Payeras_BI]

Hi @ScottCC,
It works just like this.

[ScottCC]

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