Forum Discussion
Advocate IIIHow to filter the date column for every Wednesday?
Hi experts,
I have a date column on a matrix, from 2018-10-17 to 2019-01-24, and I'd like to select Wednesday only.
It seems that the advanced filter is only capable of doing very basic filtering.
Actually, wish we could do as in pandas, i.e. pass a function to filter a column, that would be perfect because MS will never need to add tons of tiny functionalities. I think what Power BI truly lacks is not functionality, but a flexbile scripting language, like VBA in Excel.
Hi markus_zhang
you can add another column with the weekday number, using the WEEKDAY function and then filter by 4.
2 Replies
- LivioLanzo
Solution Sage
Hi markus_zhang
you can add another column with the weekday number, using the WEEKDAY function and then filter by 4.
markus_zhangThanks LivioLanzo that's a good thought!