Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
James_Ma
Frequent Visitor

Calculating working days to date

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.

 

4 REPLIES 4
selimovd
Super User
Super User

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
 

Hi Denis,

 

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

James_Ma_0-1629898097918.png

 

 

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

 

Greg_Deckler
Super User
Super User

@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.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors