topic Get previous not NULL record in Developer

Get previous not NULL record

SNik — Tue, 16 Feb 2016 04:10:01 GMT

I have some Hierarchy data like

Product Model

A NULL

NULL A1 Name

NULL A1 Description

B NULL

NULL B1 name

NULL B1 Description

NULL B2 name

NULL B2 Description

Questions:

1- what should be my approach? i know that Hierarchy is not supported yet

2- I like to "Add a Column" that will give me the previous record that is not null something like

Product Model NewColum

A NULL A

NULL A1 Name A

NULL A1 Description A

B NULL B

NULL B1 name B

NULL B1 Description B

NULL B2 name B

NULL B2 Description B

how can i do that?

thanks

Re: Get previous not NULL record

konstantinos — Tue, 16 Feb 2016 09:07:27 GMT

@SNik When you load the data in select the column "Product" go to "Transform" and then Select from the menu "Fill Down".

Then you have your new column.

Depending your data model and how you would like to display the data you can a) filter out the null values in Model or b) you can add the Product in the model column.

For the first select the column drop down menu and unselect null

For the second "Add custom column" and the formula will be

if [Model] = null then [Product] else [Model]

Hope it helps

Re: Get previous not NULL record

SNik — Thu, 18 Feb 2016 14:07:18 GMT

I love your simple and perfect solution, i know that PowerBI is not and ETL/CleanUp tool but it does alot

Anyways thank you very much

Sincerely

Nik