Forum Discussion
Filter Visual Based upon Today Week Number Measure
I have a measure: Today Week = WEEKNUM(TODAY()) And I have a Visual that I would like to filter using this measure. I have a Week Number column.
I'm still not entirely sure what you're trying to accomplish. However, if you need your measure to function as a filter, you can create something like this:
Filter_test = IF(WEEKNUM(MAX('your_table'[date])) = WEEKNUM(TODAY()), 1, 0)
Alternatively, you could simply use a relative date filter
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
I dont have the relative date option?
it should be the date column....
please share a link to your pbix.