Retrieve Last 3 working days in each month

[jayanthan]

Hi All

How can retrieve last 3 working days in each month , please advice

Thanks in Advance

Regards

Jayanthan

[LivioLanzo]

Hi @jayanthan

do you have the date table already set up?

[jayanthan]

Hi @LivioLanzo

Yes , i have , please find the calendar pbix in below given link

https://www.dropbox.com/s/pxxc5523qv6b5hj/Calendar_File.pbix?dl=0

Regards

Jayanthan

[LivioLanzo · Accepted solution]

@jayanthan

I am guessing you want to add a column which returns True for the last 3 working days in a month so you can slice by them in your report. You can do it by adding first this column:

WorkDay = WEEKDAY( [Date], 2 ) < 6

and then this one:

LastThreeDaysInMonth = 
CONTAINS(
    CALCULATETABLE(
        TOPN( 3, 'Calendar', [Date], DESC ),
        ALLEXCEPT( 'Calendar', 'Calendar'[Month], 'Calendar'[Year] ),
        'Calendar'[WorkDay] = TRUE
    ),
    'Calendar'[Date],
    'Calendar'[Date]
)

[jayanthan]

Hi LivioLanzo

Wow,It works, thank you so much for the support

Regards

Jayanthan