Dates and blanks to be values in another column

[Jess303]

I have a date field that has dates and blanks. All I would like to do is have a column that if there is date I want the value to be one and if it is blank to have a value of zero in a corresponding column.  Is this possible? Here is an example of what I would like it to look like:

Submit date	Submision
1/1/2022	1
2/4/2012	1
	0
	0
3/1/2009	1

[FreemanZ]

hi @Jess303 

try like:

Column =

IF(

  [Date]=BLANK,

 0, 1

) +0

[Jess303]

Did not work, When I am in Power query editor the blanks are null values. 

[FreemanZ · Accepted solution]

hi @Jess303 

in PQ, try like:

if [Date]=null then 0 else 1

[Jess303]

Worked like a charm, Thanks!