Forum Discussion

SNik's avatar
SNik
Helper I
10 years ago
Solved

Get previous not NULL record

Hi I have some Hierarchy data like   Product      Model   A                NULL   NULL          A1 Name   NULL          A1 Description  B                  NULL NULL            B1 name NULL  ...
Need Help
  • konstantinos's avatar
    konstantinos
    10 years ago

    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

konstantinos's avatar
konstantinos
Memorable Member
10 years ago

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

  • SNik's avatar
    SNik
    Helper I
    10 years ago

    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