Creating Conditional Column to tell if field is blank

[drewoplandevers]

Hello!

I've got data where some rows are blank for a given field. How would I create a calculated column that returns "Blank" if [Site Parcel Number] is blank for that row, and "Not Blank" if the [Site Parcel Number] field of the row is populated with anything? I've looked online, and it seems most other similar solutions apply to more specific use cases that make them non-applicable to this. Any help would be greatly appreciated.

Thanks!

[djurecicK2 · Accepted solution]

Hi @drewoplandevers ,

 You can use IF and ISBLANK to achieve this:

https://learn.microsoft.com/en-us/dax/isblank-function-dax

[drewoplandevers]

I tried ValidParcel = if((sblank('ValidRows'[Site Parcel Number]),0,1) , but the returned information is a mess. There's several hundred thousand rows, so there should be more of both. I did re-verify that the rows were actually blank. Any idea on why this wouldn't be working, the code seems right to me? Also, thanks for such a rapid reply!