filter function returns Zero's and date 00/01/1900

[GMC The Macro Man]

Hi there
I'm hoping someone can help me as I'm using the =Filter function to return data, which it does successfully, but if the cell is blank, it returns a 0 or if the column is formatted to date and its empty then it returns 00/01/1900
All my data is added in to a Table on the 1st Sheet and then i have multiple sheets where the data is to be returned.
I use =FILTER(DataInput,(DataInput[AA1]=Dashboard!D27,"")) where AA1 = the 1st criteria and D27 is the 2nd Criteria. I end this with ,"" as in theory, if the cell to be returned is blank then it should not put anything in this cell, however I get the outputs as stated earlier.
I love this function as it pulls the data over fantastic but this Blank Cell is pulling my hair out
Would love some assistance please

 

[Fluff]

Hi & welcome to MrExcel.
How about

=LET(f,FILTER(DataInput, DataInput[AA1]=D27,""),IF(f="","",f))

 

[GMC The Macro Man]

Hi & welcome to MrExcel.
How about
=LET(f,FILTER(DataInput, DataInput[AA1]=D27,""),IF(f="","",f))

Thank you so much, this worked perfectly. Much Kudos for the fast response and correct answer.
I don't have much knowledge of the LET function so would you mind explaining what has happened here, as I racked my brains trying to get a solution, so I would like to understand this better

 

[Fluff]

The LET function simply allows you to store information in a variable (in this case I called it f) which saves having to do the calculation multiple times.

 

[smozgur]

@GMC The Macro Man - Welcome to the MrExcel Message Board!

Thank you so much, this worked perfectly. Much Kudos for the fast response and correct answer.

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.