Forum Discussion

icturion's avatar
icturion
Icon for Resolver II rankResolver II
4 years ago
Solved

How to show the current week number

hi,   I have a data set with past, present and future data. Now I want to display the totals per week number in a chart. where the current week in the x-axis is stated as current.   as an example...
Need Help
  • icturion's avatar
    icturion
    4 years ago

    The problem is resolved.

    this is the solution

     

    Current Week = IF(Kalender[WeekNumber] = WEEKNUM(TODAY(),21), "Current", CONVERT(Kalender[WeekNumber],STRING))
     
    thanks Paul DBrown for helping
icturion's avatar
icturion
Icon for Resolver II rankResolver II
4 years ago

Hello PaulDBrown,

 

thank you for the quick respons. i use a calculated column with this dax formule

Current Week = IF(Kalender[WeekNumber] = WEEKNUM(TODAY()), "Current", CONVERT(Kalender[WeekNumber],STRING))
But the current week out come is wrong, i now return week 42 as current, but the correct week is 41
 
do you know how to resolve this? 
PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
4 years ago

If you use a calculated column, the data will only be updated on refresh. A measure will be refreshed whenever the measure is used.

You also need to be aware of how the week numbers are counted. The expression WEEKNUM(TODAY()) will count weeks based on:
"The week containing January 1 is the first week of the year and is numbered week 1."

 

The expression WEEKNUM (TODAY(), 2) will count weeks based on:
"The week containing the first Thursday of the year is the first week of the year and is numbered as week 1. This system is the methodology specified in ISO 8601, which is commonly known as the European week numbering system."

 

Refer to

https://docs.microsoft.com/en-us/dax/weeknum-function-dax