How to filter the date column for every Wednesday?

[markus_zhang]

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.

[LivioLanzo · Accepted solution]

Hi @markus_zhang

you can add another column with the weekday number, using the WEEKDAY function and then filter by 4.

[markus_zhang]

Thanks @LivioLanzo that's a good thought!