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
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks for this. When using:

Current Week = IF(Date_Table[Week_Number] = WEEKNUM(TODAY(),2), "Current", CONVERT(Date_Table[Week_Number],STRING))

 

I get the error:

"A single value for column 'Week_Number' in table 'Date_Table' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."

 

Any help appreciated.