Forum Discussion
Creating Conditional Column to tell if field is blank
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 [S...
Hi Anonymous ,
You can use IF and ISBLANK to achieve this:
https://learn.microsoft.com/en-us/dax/isblank-function-dax
djurecic
Super User
Super UserHi Anonymous ,
You can use IF and ISBLANK to achieve this:
https://learn.microsoft.com/en-us/dax/isblank-function-dax
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!