Forum Discussion

DustinD's avatar
DustinD
Icon for Helper I rankHelper I
3 years ago
Solved

Dax help to filter data down.

Hey guys,  im stuck on a dax problem. any help is apriceated. so below i have the date table. this date table takes 2 snapshots a week of are data. it takes the snap shots on sunday and wednesday....
  • DustinD's avatar
    DustinD
    3 years ago

    i have solved this.so the dax i have below i put into a coulmn and then put it as a visual level filter. and then i set the filter to is 4 for wednesday. 

    WedCheck =
    WEEKDAY(Fact_SalesOrderHistory[ImportDate])
Copycat's avatar
Copycat
Frequent Visitor
3 years ago

Good day,

 

as far as I understand your issue, I see two possibilites here:

  1. You can change the date format from short to long, then it will include also week day name and then you can use a slicer to filter only specific day name.
  2. You can use below formula to filter only Wednesday dates:

 

WednesdayDates = 
FILTER (
    'Table_Name', 
    WEEKDAY('Table_Name'[Column_Name]) = 4 -- 4 corresponds to Wednesday (Sunday is 1)
)