Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I applied where condition to filter date column and select only specific period but it is not working as expected.
Example Data is here
Name Date
x 07/25/2018
y 07/25/2017
z 09/25/2022
step 1 loaded the fields from the excel sheet and written the below where condition
condition is Where(Year(Date)>2017)
The problem here is After filtering the data, I created a table in Analyze sheet section which shows as below
Name Date
x 07/25/2018
y -
z 09/25/2022
I am not sure why this table has the Date column with - symbol. This means where condition is not working properly? or what mistake am I doing here?
PS: I am new to community I might be asking this Question in a wrong place
Should be greater than or equal to.
Where(Year(Date) >= 2017)