Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello everyone.
I have a column that has the values "yes", "Not Reviewed", and blanks. I would like tge blanks to return "no". Could anyone please assist with the correct measure. Your assistance is appreciated 🙂
Many thanks ChiragGarg2512
Hi @AMBP73
You can do:
Calculated_Column= IF(ISBLANK('YourTable'[Column]), "No", 'YourTable'[YourColumn])
Be aware, that you are calculating a new column.
You can also use PowerQuery editor and replace directly nulls by No
Many thanks for both of the tips. 🙂
I'm glad it works.
Don't forget to mark as solved the topic for other users which may need it
Try this measure:
measure = if(ISBLANK('table'[column]), "No", 'table'[column])
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
21 | |
21 | |
19 | |
13 | |
12 |
User | Count |
---|---|
42 | |
28 | |
23 | |
22 | |
22 |