IF and AND in Dax

[Excel Fox]

Hi I'm pretty new to Power Bi. I have 2 columns with Y and N in them. if Y appears in both for the same entry I want to return a Y, if not a N.

In excel it would be a simple if and and statement. DAX is confusing me at present!

Thanks

 

[RoryA]

It's the same in DAX:

=if(and([Field1]="Y",[Field2]="Y"),"Y","N")

 

[Excel Fox]

Thanks for this.

I know have issue. I have column which is calculating between dates and returning the number of months. I need to now create a column that will return a "Yes" if the number of months is 4 or below.

I've tried IF, IF(AND and CALCULATE with DISTINCT COUNT.

Any ideas?

Thanks

 

[RoryA]

All you need is IF.

=if([field name]<4,"Yes","No")

 

[Excel Fox]

Will this count zeros and blanks as zero's?
As that is the problem I'm having.

 

[Excel Fox]

I've also tried switch and true but the blanks count as zero's.

 

[RoryA]

What do you want it to count blanks as?