Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

Colouring this week x axis in graph

Hi Masters, I want to colour W38 to show which week we are like below. Is it possible? any advice would be much appreciated. thank you, CL

5 years ago

Anonymous Oh, wait, syntax error, missing )

Measure = 
  VAR __Date = MAX('Table'[Date])
RETURN
  IF(WEEKNUM(__Date) = WEEKNUM(TODAY()) && YEAR(__Date) = YEAR(TODAY()),1,BLANK())

Icon for Community Champion rank

Community Champion

5 years ago

Anonymous Thinking:

Measure = IF(WEEKNUM(MAX('Table'[Date]))=WEEKNUM(TODAY()),1,BLANK())

Anonymous

Not applicable

5 years ago

Hi Greg_Deckler for how, it shows 2019-38 and 2020-38 for dot..

Greg_Deckler
Community Champion
5 years ago
Anonymous Hah!, didn't think about that! OK, that's easy to fix:

Measure = VAR __Date = MAX('Table'[Date]) RETURN IF(WEEKNUM(__Date) = WEEKNUM(TODAY() && YEAR(__Date) = YEAR(TODAY()),1,BLANK())
- Anonymous
  Not applicable
  5 years ago
  Hi Greg_Deckler thanks for your reply.
  I honestly have no idea of this dax..
  
  this time, it didn't appear?
  - Greg_Deckler
    Community Champion
    5 years ago
    Anonymous Oh, wait, syntax error, missing )
    
    Measure = VAR __Date = MAX('Table'[Date]) RETURN IF(WEEKNUM(__Date) = WEEKNUM(TODAY()) && YEAR(__Date) = YEAR(TODAY()),1,BLANK())

Related content