How to create a new column with the nearest greater date from another table in power query

[IanT]

Hi, 

I'm new to Power BI and looking to solve the following issue.

I'd like to be able to add a new column using M (or dax if that is the only way) to a table that looks up the nearest greater date from another table column, as below.

Any suggestions?

Thanks

Ian

[ryan_mayu · Accepted solution]

@IanT 

here is a DAX solution

Column = MINX(FILTER('Table (2)','Table (2)'[Date]>'Table'[date]),'Table (2)'[Date])

[IanT]

Thank you so much @ryan_mayu , such a simple solution! 

[ryan_mayu]

you are welcome