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 All,
Can anyone give me a pointer on how to do/write an expression on how to replace null values with the value inside a cell above it or with the value of the first cell above it that does not have null value?
Please see below table that I'm working with. Thank you very much before hand.
Solved! Go to Solution.
@MelbourneBadger , one option is data transformation mode right click on the column and use replace. You use null for null and give the value to be replaced
refer
https://www.youtube.com/watch?v=-fwKhMot9hw
https://www.youtube.com/watch?v=EoRjNx1G2g4
https://forum.enterprisedna.co/t/replace-null-values-to-another-value-in-table-power-bi/3019
@MelbourneBadger , one option is data transformation mode right click on the column and use replace. You use null for null and give the value to be replaced
refer
https://www.youtube.com/watch?v=-fwKhMot9hw
https://www.youtube.com/watch?v=EoRjNx1G2g4
https://forum.enterprisedna.co/t/replace-null-values-to-another-value-in-table-power-bi/3019
Thank you very much with the suggestion. The Fill-Down function actually work to replace the Null with the values required.
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |