Forum Discussion

telesnate's avatar
telesnate
Regular Visitor
1 year ago
Solved

Relative Date Slicer (Skipping Weekends)

Hi there,    I have a report with data that is only created on weekdays. I have no weekend data whatsoever.   I have a relative date slicer and when I set it to "last 1 day", I want it to show me...
  • andrewsommer's avatar
    1 year ago

    I would create a flag on my data table that identified the last date.  If your fact table does not have data at all on the weekends and thus you want to show the most recent weekday with data

     

    Flag_Day_Prior = IF('Date_Table'[Date] = MAX(Fact_Table[Date]),1,0)

     

    Add this field to your measure as a filter and set it = 1

     

    Please mark this post as solution if it helps you. Appreciate Kudos.

  • danextian's avatar
    1 year ago

    Hi telesnate 

    The Relative Date slicer in Power BI does not support filtering to include only weekdays or weekends within the past X days.

    This question has already been addressed previously.
    Please refer to the following resources for more details: