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

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?

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

Anonymous
Not applicable
5 years ago
Greg_Deckler oh.. that's too bad.... okay thank you so much for your help in anyways! 🙂
Greg_Deckler
Community Champion
5 years ago
Anonymous Sorry we couldn't get there completely in the end, but if this at least gets you something, mark it as an answer so others can benefit! 🙂