Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Current week/year true or false

I have a column in my data called 'week of' and it displays the date for the Monday of that week. For example, this week the date listed is November 7, 2022.

 

I want to create a new column that provides a true or false value, based on whether the date showing in the week of column is the current week and year.

 

For example: It would show true for the line item with November 7, 2022, in the week of column, but false for November 14, 2022. 

Need Help
  • Bifinity_75's avatar
    Bifinity_75
    3 years ago

    Hi Anonymous , try this calculate column:

    Result = 
var _year= YEAR(Table_example[Date])
var _week=WEEKNUM(Table_example[Date])
var actual_week=WEEKNUM(TODAY())
var actual_year= YEAR(today())
return 
IF(_year=actual_year && _week=actual_week,"True","False")

    - The result:

     

    Best regards

     

1 Reply

  • Bifinity_75's avatar
    Bifinity_75
    Solution Sage
    3 years ago

    Hi Anonymous , try this calculate column:

    Result = 
var _year= YEAR(Table_example[Date])
var _week=WEEKNUM(Table_example[Date])
var actual_week=WEEKNUM(TODAY())
var actual_year= YEAR(today())
return 
IF(_year=actual_year && _week=actual_week,"True","False")

    - The result:

     

    Best regards