Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I'm testing a simple column to test blank values on column but i can't get what i want here is an exp :
I had left a blank row to see how it works but without result
Solved! Go to Solution.
@FZOU , try
if(coalesce(Table[Column2],"")="","A","B")
@Greg_DecklerIt works fine but why the ISBLANK function doesn't work properly ? maybe i'm not use it correctly
blank and empty value are not always the same
1. make sure you have no service symbols in your column (execute trim operation in Power Query)
2. try statement like
= IF(ISBLANK(table[Column]) || table[Column]=''; "a"; "b")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |