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