Highlight every week's total in table

hi, manishpadmajan 

use below measure for conditional formatting

Measure = 
var a = CALCULATE(MAX('Table (2)'[weekly total]),ALLEXCEPT('Table (2)','Table (2)'[week]))
return
IF(MIN('Table (2)'[weekly total])=a,"#FFFF00")

1. click on weekly total coluymn 

and follo step in iamge

change format style to field value

3. click on table name where measure is present and choose that measure and click on OK

download .pbix file click  HERE 

Hi manishpadmajan 

For your question, you've completed the first requirement, and here I'm helping you with the second:

Here's some dummy data, based on what you provided, I also created the "week" calculated column.

You want to highlight the weekly total, you can create a measure to query the last day of the week and makes it as “1”.

IsLastDayOfWeek = 
var max_date = CALCULATE(MAX('Table'[Date]), FILTER(ALL('Table'), 'Table'[Week] = MAX('Table'[Week]) ))
var _date = SELECTEDVALUE('Table'[Date])
return IF(_date = max_date, 1, 0)

Set the highlight for “WeeklyTotal” according to the “IsLastDayOfWeek”

Here is the result

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.