Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
My excel file has merged cells. When loads in query, only the first cell has value, others are blanks. How can i use power query to fill the same value for blank cells?
Thanks,
Solved! Go to Solution.
@kient ,
In Edit query, you have a replace option
https://www.edureka.co/community/40467/replace-null-values-custom-values-power-power-query-editor
https://bengribaudo.com/blog/2018/06/26/4470/power-query-m-primer-part6-types-intro-text
In dax you can use isblank to check and coalesce to handle null
Column = coalesce('Table' [A], "NA" )
Or
Column = if ( isblank( 'Table' [A]), "NA" , 'Table' [Province])
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |