Forum Discussion
jamjoom
3 years agoNew Member
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...
- 3 years ago
=let a=List.Max(Employee[Date of Birth]) in Table.SelectRows(PreviousStepName,each [ValueDate]>a)
wdx223_Daniel
3 years agoCommunity Champion
=let a=List.Max(Employee[Date of Birth]) in Table.SelectRows(PreviousStepName,each [ValueDate]>a)
- jamjoom3 years agoNew Member
thank you so much!