If Not Blank AND If Blank Statement

[duesouth]

I'm new to Power BI and looking for a bit of help. I've got 2 date fields and want to create a column from these.

If the [Start Date] is NOT blank AND the [End Date] IS blank then return "Yes", else return "No".

I've been googling like mad for 2 days, but no joy - so any help greatly appreciated for a rookie!

 

[RoryA]

Welcome to the forum.

Are you trying to do this in power query or as a calculated column using DAX?

 

[duesouth]

A new column in DAX. Thanks!

 

[RoryA]

Then it would be:

=if(and(NOT(ISBLANK(Table1[Start Date])),ISBLANK(Table1[End Date])),"Yes","No")

amending the table name as needed.

 

[duesouth]

Then it would be:

=if(and(NOT(ISBLANK(Table1[Start Date])),ISBLANK(Table1[End Date])),"Yes","No")

amending the table name as needed.

Thank you so much!

 

[RoryA]

Glad we could help.