So basically i'm comparing the week of work_dt with week of today().
Although it hides current week's data but it also has an unintended consequence. If the current week is week 45, then it is eliminating week 45 from all years and showing data till week 44 for all the historical years as well.
I think i need to add a condition for year in the expression but I'm not able to get the correct expression.
In the line chart that I had created for these work dates, I was showing the value on the just the last week.
The expression that I used was this:
[Week] = $(=Week(Today())-1)
This was showing the data for just the last week but this expression also has the same issue of showing data for corresponding week number for previous years also. For example, if current week is week 2, then value should appear only on week 1 of 2018 and not on week 1 of 2017 or 2016.
(value appearing on just the last week of 2018 i.e. week 1, current week of 2018 has been made hidden)
(value appearing on week 1 of 2017 also).
I tried using weekstart function here also but it did not work me. Any suggestion?