topic Re: Calculating working days to date in DAX Commands and Tips

Calculating working days to date

James_Ma — Tue, 24 Aug 2021 13:28:55 GMT

Hi all,

I have a question regarding how to count he number of working days to todays date?

I have a mode where I am using calendar year, calendar month and then counting the "Is working day" to show that between 2019 and 2021 there would be 760 working days (UK).

As 2021 is not yet complete, is it possible to count the working days until today?

I am working on another calcualtion to divide the number of working days by the number of days people have worked to work on an efficiency value.

Any help would be good.

Re: Calculating working days to date

Greg_Deckler — Tue, 24 Aug 2021 13:33:03 GMT

James_Ma If you have a calendar table or a VAR with your calendar table in it, just use FILTER for [Date] <= TODAY()

If that isn't helpful. Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

Re: Calculating working days to date

selimovd — Tue, 24 Aug 2021 13:34:17 GMT

Hey James_Ma ,

that should be possible. You can just limit the filter context for dates until today.

Try an approach like that:

Working days until today = CALCULATE( COUNTROWS( DateTable ), DateTable[Is working day] = 1, DateTable[Date] <= TODAY() )

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

Re: Calculating working days to date

James_Ma — Tue, 24 Aug 2021 14:03:19 GMT

Thanks Denis, but that has not worked, I will post up some of the data later

Re: Calculating working days to date

James_Ma — Wed, 25 Aug 2021 13:28:34 GMT

Hi Denis,

It did infact work, however it counts the working days but I tcannot be filtered by the Calendar year?