Power Query - Filter to Numbers equal to or greater than

[gheyman]

I have a table that has a field with numbers in it.

That field is a custom field that subtracts todays date from the date in another field
= Table.AddColumn(#"Sorted Rows", "Validity", each Duration.Days(Date.From(DateTime.LocalNow()) - Date.From([EndDate]))*-1)

I want the User to be able to enter a number and the table filters the Validity column to show only numbers equal to or greater than the number the user enters.

I have a UserForm where the User enters that number and it is stored in a table on a tab named Validity. On that tab I have a table named Validity Days. That table I converted to a List called Selected_Validity_Days

I assume its something like this except I don't know how to do the greater than part. I do want it show all if the user does not enter a number

List.Contains(Selected_Validity_Days,[Validity]) or List.NonNullCount(Selected_Validity_Days)=0)

I appreciate the help and training!

 

[JGordon11]

Something like

Table.SelectRows(YourTableName, let isNull = (CheckNum = null) in each isNull or [Validity]>=CheckNum)

Where CheckNum is the number the user entered (or null), and YourTableName is the table you want to filter

 

[gheyman]

Thanks!