Power Query - Filter based on date

[gheyman]

I have a table/List that contains a date (Date_Parameter)

How do I filter the column "StartDate" to show results equal to or greater than the value in the Date_Parameter. Also need to show all if the Date_Parameter is null.

Thanks!

 

[johnny51981]

Hey @gheyman
Is the Date_Parameter a single date or is there more than in the table/list?

If there is only one, then you can create a Filtered Rows Step:

= Table.SelectRows(#"PREVIOUS_STEP", each [StartDate] >= (DateTable[Date_Parameter]{0}) or [StartDate] = null)

I hope I have understood your question correctly.

 

[gheyman]

Single

 

[johnny51981]

Ok then yeah, that M Code I provided should work out for you.

 

[gheyman]

Thank you!