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.
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])
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 |
---|---|
104 | |
96 | |
80 | |
67 | |
62 |
User | Count |
---|---|
137 | |
106 | |
104 | |
81 | |
63 |