Forum Discussion

Ferraz's avatar
Ferraz
New Member
2 years ago
Solved

Replacing null value

HI, in powerBI, I need to find a crafty formula to fill in the cells of the last column. Below is the screenshot taken from PowerBI:     To better explain what I need to do, I'll reproduce e...
Need Help
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    Hi Ferraz 

    1. In Power Query, create a Duplicate table from Exisiting Table

    2. Only keep IDRigis & ANAGRAFICA column
    3. Remove null value from ANAGRAFICA column
    4. Then Marge with 1st table with Duplicate Table with IDRigis (innerjoin)
    5. Expand the ANAGRAICA column (new column name will created as ANAGRAICA_2)
    5 Remove the main ANAGRAICA column and rename  ANAGRAICA_2 as ANAGRAICA


    If solved your requirement, please mark this answer as SOLUTION.
    If this comment helps you, appreciate your KUDOS

    Thanks
    Pijush

    Do you like the theme, download it here https://community.fabric.microsoft.com/t5/Themes-Gallery/Retails-Sales-Analysis-BBG-BGV/td-p/3576304

     






PijushRoy's avatar
PijushRoy
Community Champion
2 years ago

Hi Ferraz 

1. In Power Query, create a Duplicate table from Exisiting Table

2. Only keep IDRigis & ANAGRAFICA column
3. Remove null value from ANAGRAFICA column
4. Then Marge with 1st table with Duplicate Table with IDRigis (innerjoin)
5. Expand the ANAGRAICA column (new column name will created as ANAGRAICA_2)
5 Remove the main ANAGRAICA column and rename  ANAGRAICA_2 as ANAGRAICA


If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS

Thanks
Pijush

Do you like the theme, download it here https://community.fabric.microsoft.com/t5/Themes-Gallery/Retails-Sales-Analysis-BBG-BGV/td-p/3576304