Values on the week 1st day

[Sriharsha_Akkin]

Hi,

I am trying to create a measure which  only brings  in value for the first day  of the week.

I tried to create using filtered measures but  couldnt make it work. 

For ex, take the value of GOOG stock. it varies every day. Now I want a measure which would return only the value on monday or tuesday(if monday is a holiday).

lets say my filter is set and for the last 2 days and stock name as GOOG it should show as below

Stock Name        Date           Value        valueonweek1st day

GOOG           10/12/2021       $1000      $995

GOOG           10/11/2021          $995      $995

The right  most column has only values for the week1st day, is there  a way to achieve this  with lookml