Week Calculaltion

RENJITH_R_S  If you want a new column, you can use this formula:

Colour column =

VAR _DVweek = WEEKNUM(table[DateValue])

VAR _Todayweek = WEEKNUM(Today())

RETURN

SWITCH(TRUE()

, table[Value] = "d" , "Green"

, table[Value] = "a", "Grey"

, _DVweek = _Todayweek , "Blue"

, _DVweek +1 = _Todayweek, "Yellow"

,  "Red"

)

Note: This uses week number, so sun-mon. If you want rolling week, you can ammend the formula slightly and use DATEDIFF function.

Hi RENJITH_R_S 

It's not entirely clear what you want, for example, what do you mean by this week?  Are you talking within the last 7 days, or the 7 days starting from last Sunday/Monday?

Also, not sure what the colour/number table is for.  Do you want the name of the colour as output or a number?

Try this

Column = SWITCH(
    
        TRUE(),
        
        'Table'[Value] = "d", "Green",
        
        'Table'[Value] = "a", "Grey",

        DATEDIFF(DATEVALUE('Table'[Datevalue]), NOW(), DAY) <= 7, "Blue",

        DATEDIFF(DATEVALUE('Table'[Datevalue]), NOW(), DAY) >= 7 && DATEDIFF(DATEVALUE('Table'[Datevalue]), NOW(), DAY) <= 14, "Yellow",

        DATEDIFF(DATEVALUE('Table'[Datevalue]), NOW(), DAY) >= 14, "Red",

        ""
    )

regards

Phil

RENJITH_R_S , Create a new column like

Create a column like
Week Color = Switch( True(),
(Table[Value]) = "d", "Green",
(Table[Value]) = "2", "Grey",
[DateValue] >=today()+-1*WEEKDAY(today(),2)+1 && [DateValue] >= today()+ 7-1*WEEKDAY(today(),2) ,"blue" ,
[DateValue] >= today()+-1*WEEKDAY(today(),2)+1 -7 && [DateValue] >= today()+ 7-1*WEEKDAY(today(),2)-7 ,"yellow" ,
"red"
)

// for monday week WEEKDAY(today(),2)

//for Sunday Week WEEKDAY(today(),1)