Forum Discussion
Helper IDax 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. i would like to filter this down to only see the snap shots taken on wednesday. how would i go about this in dax? thanks!
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])
3 Replies
v-jianboli-msftCommunity Support
Hi DustinD ,
Sorry for that the information you have provided is not making the problem clear to me. Can you please share more details to help us clarify your scenario?
Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.
Refer to:
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Good day,
as far as I understand your issue, I see two possibilites here:
- 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.
- 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) )
DustinDi 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])
