Retrieve previous day values excluding weekends and holidays

Hi ghost10,

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  

To calculate the previous date values, you can try to use the following measure formulas:

formula =
VAR currDate =
    MAX ( Table[Date] )
VAR holidayList =
    VALUES ( Holiday[Date] )
VAR prevDate =
    CALCULATE (
        MAX ( Table[Date] ),
        FILTER (
            ALLSELECTED ( Table ),
            [Date] < currDate
                && WEEKDAY ( [Date], 2 ) <= 5
                && NOT ( [Date] IN holidayList )
        ),
        VALUES ( Table[Category] )
    )
RETURN
    CALCULATE (
        SUM ( Table[Value] ),
        FILTER ( ALLSELECTED ( Table ), [Date] = prevDate ),
        VALUES ( Table[Category] )
    )

Regards,

Xiaoxin Sheng