Isnull

[Anonymous]

Hi,

I have a table and would like to only show rows where there is no date (nulls).

I tried =ISNULL(Date) in the expression box but this does not exclude the rows with dates.

Currently looks like:

ID	DATE
1	2018-01-01 10:00:00:000
2	Null
3	Null

What I would like:

ID	DATE
2	Null
3	Null

Could someone please help me as to how I can achieve this?

Thank you in advance for any help.

[Chanty4u · Accepted solution]

try

May be a calculated Dimension:

If(Len(Trim([DATE])) = 0, 'Null', Null())

[Anonymous]

Hi Mateusz,

I am still getting rows with today's date.

[Anonymous]

Hi Nagaian,

Still showing rows with today's date.