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,
I want to convert all the NaN into the value of the previous row that have a non NaN value. Please can anyone help me.
I have looked uo the below link, but it wasn't helpful
Solved: Power Query- how to replace null with previous row... - Microsoft Power BI Community
Thank you in advance
Solved! Go to Solution.
You need to do this data transformation using power query. Open the query editor as per the following screenshot
Right click on the column that you want to perform transformation on and select "replace values" then right click again and select "fill" "down"
I have the data in PowerBI
Ho do i Fill Down?
You need to do this data transformation using power query. Open the query editor as per the following screenshot
Right click on the column that you want to perform transformation on and select "replace values" then right click again and select "fill" "down"
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 |
---|---|
39 | |
25 | |
20 | |
14 | |
8 |
User | Count |
---|---|
71 | |
48 | |
46 | |
20 | |
16 |