Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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"
User | Count |
---|---|
57 | |
21 | |
21 | |
19 | |
16 |
User | Count |
---|---|
86 | |
84 | |
52 | |
37 | |
23 |