Dax Formula Problem

[dkbollig]

Hey There!

I have a problem where i want to fill in a column with either "Registered" or "Not Registered" depending if there is a date in the [warranty received date] column. If there is a date in [warranty received date] it is "Registered", if there is not a date it is not "Not Registered". My current formula =IF([Warranty Reg Rcvd]="","Not Registered","Registered"). is throwing me an error when there is a date in the column. Any help would be awesome. I am fairly new to this so excuse me if its a simple fix but ive been working on this for a while.

Thanks
Derek

 

[RoryA]

Have you tried:
=IF(ISBLANK([Warranty Reg Rcvd]),"Not Registered","Registered")

 

[dkbollig]

RoryA

You Nailed It.

Thanks!
Derek