Forum Discussion

Anonymous

Not applicable

6 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

6 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())

Anonymous

Not applicable

6 years ago

I used Week but this made up based on date like below

Community Champion

6 years ago

Anonymous I think it was a syntax error on my part, corrected below.

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