Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
Solved! Go to Solution.
Hi @drewoplandevers ,
You can use IF and ISBLANK to achieve this:
https://learn.microsoft.com/en-us/dax/isblank-function-dax
Hi @drewoplandevers ,
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!
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
72 | |
38 | |
30 | |
26 |