Blanks showing in Date Data

[mshamsiev]

Hi all,

I've run a query that sets up a date table. However, when I utilise the data in the reports, I've got all the required data but also 'blank.' When I run through the data, there is no blanks showing. 

Any idea why this may be and how can I delete the blanks (if they exist).

Thanks!

Mike 

[v-chuncz-msft]

@mshamsiev,

You may add one step in the Advanced Editor, or simply click "Remove Empty".

    #"Filtered Rows" = Table.SelectRows(Source, each [date] <> null and [date] <> "")

[mshamsiev]

Hey again @v-chuncz-msft,

I've tried both approaches to no avail. 

[v-chuncz-msft]

@mshamsiev,

It would be better if you could share us the .pbix file.