Forum Discussion
jimpatel
Post Patron
Post PatronFormula for previous date
Hi, Thanks for looking at my post. I am trying to get formula for following logic please. I have "Received Date" column, if today()-1 = Received date then show that row and if today() fall o...
You could create a measure like
Row is visible = VAR startDate = SWITCH ( WEEKDAY ( TODAY (), 1 ), 2, TODAY () - 3, TODAY () - 1 ) RETURN IF ( SELECTEDVALUE ( 'Table'[Received date] ) >= startDate, 1 )and then use that as a filter on your table or matrix visual, to only show when the value is 1
You could modify it like
Row is visible = VAR startDate = SWITCH ( WEEKDAY ( TODAY (), 1 ), 2, TODAY () - 3, TODAY () - 1 ) RETURN IF ( SELECTEDVALUE ( 'Table'[Received date] ) >= startDate && SELECTEDVALUE('Table'[Received date]) < TODAY(), 1 )
johnt75
Super User
Super UserYou could create a measure like
Row is visible =
VAR startDate =
SWITCH ( WEEKDAY ( TODAY (), 1 ), 2, TODAY () - 3, TODAY () - 1 )
RETURN
IF ( SELECTEDVALUE ( 'Table'[Received date] ) >= startDate, 1 )and then use that as a filter on your table or matrix visual, to only show when the value is 1