I need help with syntax of a filter

[EaglesTony]

I have this, but not getting the results I want:

= Table.SelectRows(Issues_table, each ([StartDate] <> null and [DueDate] <> null))

What I need is

1) if StartDate is null, but DueDate is not null, I want these records

2) if DueDate is null, but StartDate is not null, I want these records

3) if StartDate is not null and DueDate is not null, I want these records

[Fowmy]

@EaglesTony 

Not clear about your question, if you are looking for DAX Filter function, here you go: FILTER – DAX Guide

[EaglesTony]

Thanks, but I'd rather do it in PowerQuery, since I want to filter my data first.

Here is an example of Data

Key      StartDate    DueDate

123      1/1/2025     null

456       null             2/1/2025

789       null             null

000       1/2/2025    1/15/2025

In this case I only want "123", "456" and "000"

[Fowmy · Accepted solution]

@EaglesTony 

Try this please: 

Table.SelectRows(Issues_table, each ([StartDate] <> null or [DueDate] <> null))

[EaglesTony]

Work perfectly!..thanks