Reporting on data older than 15 days but considering working days only.

[Ingo_LCC]

Hi team.

I am trying to report from a data set only on data older than 15 business days.
I managed to display older than 15 days but cannot find a solution to consider the holidays for my area, as I only want the working days in the 15.

Application.lodgeDateolder3Weeks =

IF(

    DATEDIFF('Applications ONLY'[Applications.LodgedDate],TODAY(),DAY) >=15,

    TRUE(),

    FALSE())

I created an individual column for our holidays that has True and False as statements.

Any ideas?

Any assistance is appreciated.

Thank you.

[lbendlin]

Have you looked at this new function? NETWORKDAYS function (DAX) - DAX | Microsoft Docs

[Ingo_LCC]

Thank you for providing a solution.

However, I'm trying to count my active applications older than 15 days and not count the days.

Except I am not seeing 'the forest because of all the trees' 😉

Kind regards.

[lbendlin]

Please provide sanitized sample data that fully covers your issue. I can only help you with meaningful sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. Screenshots of your source data are not useful.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[Anonymous]

Hi @Ingo_LCC,

Any update on this? Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng