Relative Date Filtering - Ignore Weekends

[kinga]

I have a visual that is looking at a calculation with a relative date filter set to view the last 1 day (ignoring today). When Monday rolls around I don't want it to display the last day of Sunday, I want it to show the last day as Friday. Essentially, I want it to ignore weekends. I put an additional visual filter on excluding 1 and 7 for Sunday and Saturday, however I believe the relative date filter will still try to pull from the previous day and will display nothing.

[Eric_Zhang]

---

@kinga wrote:

I have a visual that is looking at a calculation with a relative date filter set to view the last 1 day (ignoring today). When Monday rolls around I don't want it to display the last day of Sunday, I want it to show the last day as Friday. Essentially, I want it to ignore weekends. I put an additional visual filter on excluding 1 and 7 for Sunday and Saturday, however I believe the relative date filter will still try to pull from the previous day and will display nothing.

---

@kinga

Instead of the relative filter, you may just create some measure as

Measure  =
IF (
    WEEKDAY ( TODAY () ) = 2,
    SUMX (
        FILTER ( yourTable, yourTable[date] = DATEVALUE ( TODAY () ) - 3 ),
        yourTable[value]
    ),
    SUMX (
        FILTER ( yourTable, yourTable[date] = DATEVALUE ( TODAY () ) - 1 ),
        yourTable[value]
    )
)

[parry2k]

I don;t think out of box relative filtering will work in your case, in past I created my own relative filtering and that will do the job.

Basically I added a calculated field with current date as 0 and previous day as -1, -2 and so on, you can expand on this concept, ignore sat/sun and then use this new filter in page level filter where "days passed" = -1 which will always be previous day