Replace null value untill

Question

Hi all,&nbsp;Question: My datasource is an xls document with in colum1 an customer, colum2 dates, etc.But Colum 1 also contains the value null :&nbsp;Colum 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Colum 2Customer 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2016-01-02null&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2016-01-03null&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2016-01-04Customer 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2016-01-02null&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2016-01-03null&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2016-01-04Customer&nbsp;3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2016-01-02null&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2016-01-03null&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2016-01-04Customer&nbsp;4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2016-01-02null&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2016-01-03null&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2016-01-04&nbsp;Is it possible to replace the&nbsp;null&nbsp;with the name of that customer? So that we get this:&nbsp;Colum 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Colum 2Customer 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2016-01-02Customer 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2016-01-03Customer 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2016-01-04Customer 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2016-01-02Customer 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2016-01-03Customer 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2016-01-04Customer&nbsp;3&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2016-01-02Customer&nbsp;3&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;2016-01-03Customer&nbsp;3&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;2016-01-04Customer&nbsp;4&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2016-01-02Customer&nbsp;4&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2016-01-03Customer&nbsp;4&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2016-01-04&nbsp;&nbsp;I hope this is possible!&nbsp;Thanks!

anonymous · Accepted Answer

Anonymous,You can use Fill down feature in Query Editor of Power BI Desktop to achieve the above requirement.Regards,Lydia

Forum Discussion

Replace null value untill

1 Reply

Related content

Replacing values with Iterations

Replace Errors values with Null values

Replace values

how to dynamically replace values for multiple columns

Replace multiple values at once (replace value)