Working day table (that updates without visual relative date filter)

Hi  Anonymous ,

It's not very clear which fields you want in your PBIX file.... If you want to find which are working days, you can find out the holiday table in your area and import it into Power BI Desktop to mark which are off days and which are working day

I created some data:

2022 Holiday：

Calendar table：

Calendar table =

CALENDAR(DATE(2022,1,1),DATE(2022,12,31))

Information：

Here are the steps you can follow：

1. Create calculated column.

IsHoliday =
IF(
    ISBLANK(RELATED('2022 Holiday'[Date]))=FALSE(),
    1,0)

Week = WEEKDAY('Calendar table'[Date],2)

Flag1 =
IF(
    'Calendar table'[IsHoliday]=1||'Calendar table'[Week] in {6,7},1,0)

Index =
RANKX(FILTER('Calendar table',[Flag]=0),[Date],,ASC,Dense)

closest to today =
var _todayIndex=CALCULATE(MAX('Calendar table'[Index]),FILTER(ALL('Calendar table'),'Calendar table'[Date]=TODAY()))
return
CALCULATE(MAX('Calendar table'[Date]),FILTER(ALL('Calendar table'),[Index]<_todayIndex))

2. Create measure.

Flag =
IF(
    MAX('information'[Date])=MAX('Calendar table'[closest to today]),1,0)

3. Place [Flag]in Filters, set is=1, apply filter.

4. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly