I need to calculate yesterday based on a date parameter and that yesterday cannot be a holiday

Hi Team,

I am trying to achieve one scenario.

Step-1: Connected to Data Sources

Primary Data Source: Data(It cannot contain Holidays/Weekends, only Business Days Data)

Secondary Data Source: Holiday List(It contains holidays, no weekends)

Step-2: Established the blending

Created a date Parameter(Received Date)

Primary Data Source: Created a calculated field(Received Date Calculation)

// IF Received Date is a Monday then yesterday should be Friday

IF DATEPART('weekday',[Received Date])=1 // Sunday

THEN [Received Date]-2 // Friday

ELSEIF DATEPART('weekday',[Received Date])=2 // Monday

THEN [Received Date]-3 // Friday

ELSE [Received Date]-1 // Actual Yesterday

END

Secondary Data Source: Created a calculated field(Weekday)

DATEPART('weekday',[Holidays Date])

Blending is on Received Date Calculation and Holidays Date

Step-3: Created a Calculated Field to see if yesterday is a holiday or not.

Primary Data Source: Created a calculated field(Holiday?)

IF [Received Date Calculation] = ATTR([Holidays (Data)].[Holidays Date])

THEN 'Holiday'

ELSE 'Regular Day'

END

Primary Data Source: Created a calculated field(Date Equality)

[Data Received Date] = [Received Date Calculation]

Kept the field Date Equality as TRUE in Filter Shelf.

Stuck at:

If Yesterday is Holiday, then go to previous day and check is previous day was also a holiday or not etc.

Example:

Scenario-1: Data Received Date: 17 April

Yesterday is 16 April

Holiday?: Regular Day

So Yesterday or Received Date Calculation is 16 April

Scenario-2: Data Received Date: 14 April

Yesterday is 13 April(but a weekend so move to Friday)

Yesterday is 11 April

Holiday?: Regular Day

So Yesterday or Received Date Calculation is 11 April

Scenario-3: Data Received Date: 22 April

Yesterday is 21 April

Holiday?: Holiday

Check for 18 April

Holiday?: Holiday

Check for 17 April

Holiday?: Regular Day

So Yesterday or Received Date Calculation Should be 17 April

How can I achieve this?

Note: No Weekends. If today is Sunday or Monday, it should be treated as Friday.