Forum Discussion

jimpatel's avatar
jimpatel
Icon for Post Patron rankPost Patron
4 years ago
Solved

Formula 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...
  • johnt75's avatar
    johnt75
    4 years ago

    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

  • johnt75's avatar
    johnt75
    4 years ago

    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 )
jimpatel's avatar
jimpatel
Icon for Post Patron rankPost Patron
4 years ago

Thats perfect. Thanks a lot for your help. 

One question, why i cannot put measure in the filter? That is i used your formula and i am getting 1 for correct filter. I am thinking of putting filter with 1 and blank, in the report view, but it does not allow me to put the above measure in the filter. Any idea please?

 

Thanks