Forum Discussion

jamjoom's avatar
jamjoom
New Member
3 years ago
Solved

Filtering column based on another table | power query

Hi All,   I have the following tables:   Employee Name Date of Birth Andrew 5/13/1998 Michael 9/3/1990   SalesByCity City Sales Date Orlando 2,000,000 5/14/2001 Sc...
  • wdx223_Daniel's avatar
    3 years ago

    =let a=List.Max(Employee[Date of Birth]) in Table.SelectRows(PreviousStepName,each [ValueDate]>a)