Power BI M Customer Column Where Flag is True AND date is NULL then 'true' Else False

[DebbieE]

Im struggling to find customer column examples

I basically want

Where Flag = True

AND Date is NULL

Then True

Else False

Ill keep looking but if anyone can give me the code that would be great

[DebbieE]

This is as far as I got. notice the error

[amitchandak]

@DebbieE , try

= If [Flag] = true and Date = null then true else false

Or this

=[Flag] = true and Date = null

refer 

http://excel-inside.pro/blog/2018/05/17/comparing-null-values-in-power-query/

[DebbieE]

the initial one created an error

I dont understand the second one because its just setting up the True and Null part of the logic without saying what you want to do

[DebbieE · Accepted solution]

That was really odd.

To get over the above issue I created a Conditional Column

then I changed the M Code so it said ANd in it. this changed it into a custom column and it worked with the code as above. I dont really understand how but it did the trick