Forum Discussion

nirvana_moksh's avatar
nirvana_moksh
Icon for Impactful Individual rankImpactful Individual
7 years ago

Measure to filter correct date from another table

Hello All,   I am running into an issue creating this measure which is driving me nuts. For this example, I have two tables. One has a List of Dates which is used as a filter as below: which...
Need Help
Show and Tell
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

nirvana_moksh your request is not clear, isn't when 5/16/2018 selected, it should return 5/15/2018 instead of 5/14/2018???

nirvana_moksh's avatar
nirvana_moksh
Icon for Impactful Individual rankImpactful Individual
7 years ago

parry2k- Sorry about that, I have edited and corrected my post now

 

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    7 years ago

    nirvana_moksh try adding following measure

     

    Recent Date = 
VAR __baseDate = SELECTEDVALUE('List Date'[Date])
RETURN
CALCULATE( MAX(Table[Start Date]), Table[Start Date] <= __baseDate )

     

    • nirvana_moksh's avatar
      nirvana_moksh
      Icon for Impactful Individual rankImpactful Individual
      7 years ago

      parry2k - Sadly that did not work, I had tried something similar as well and I think what it ends up doing is checking MAX os the start dates instead of seeing it in relation to the filter selected. Below is what it returned when I used the measure suggested:

       

      • parry2k's avatar
        parry2k
        Icon for Super User rankSuper User
        7 years ago

        nirvana_moksh doesn't make sense, share the pbix file thru one drive/google drive, remove any sensitive inforamtion