Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
Solved! Go to Solution.
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.
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.
Good day,
as far as I understand your issue, I see two possibilites here:
WednesdayDates =
FILTER (
'Table_Name',
WEEKDAY('Table_Name'[Column_Name]) = 4 -- 4 corresponds to Wednesday (Sunday is 1)
)
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.
User | Count |
---|---|
66 | |
46 | |
20 | |
19 | |
15 |
User | Count |
---|---|
121 | |
41 | |
38 | |
28 | |
23 |