Create column with DAX to determine if date is the current week or not.
I have a date column I would like to evaluate and create another column that determines if the date is in today's week or not. How can I do this?
In the below example the column "Load Date (including STO)" I want to evaluate. Today is Tuesday 4/21/20 so the current week is Monday 4/20/20 - Sunday 4/27/20. Any days that are in the current week I want my new column to display, "Current Week" otherwise "Not Current Week"
Maybe a bit late, but this solution won't work very well.
Weeknr are nog fully matched with years. So week 1 of 2020 can start on 30th dec of 2019.
So it is 2020 Week 1 but date is 30-12-2019. When viewing your report on 2nd of january, it will not show me the first 2 days of the current week, this can really give wrong information.... when working with dates and weeks, you should always use a separate yearcolumn to attacht to the weeks, to do this properly. I always have a year-month combination and a separate year-week combination.