Forum Discussion

dsj8wksnnckk's avatar
dsj8wksnnckk
Resolver I
3 years ago
Solved

Complement values to a defined value

Hi all, I'm trying to figure out how to solve the following challenge. I have these two tables with data   What I want to achieve is the following:   Short explanation: I ...
Need Help
rubayatyasmin's avatar
rubayatyasmin
Community Champion
3 years ago

Hi, dsj8wksnnckk 

 

I have reproduced your problem and was able to solve it. 

Need to transform. I am adding the pbix file. 

AddP4 Rows.pbix

 

Result:

 

 

 

  • dsj8wksnnckk's avatar
    dsj8wksnnckk
    Resolver I
    3 years ago

    Hey,

    thanks for the assistance.

    I'm not quite sure this solution would be applicable. I see one of your steps is transpose table, but my table will have unlimited number of rows (thats what the 3 dots mean on the bottom).

    What do you think?

    • rubayatyasmin's avatar
      rubayatyasmin
      Community Champion
      3 years ago

      Hey, If you check it again, those were the automated steps that PQ performed. I took a sheet not a table when importing data to PBI PQ. So those were the unnecessary steps. 

      See below image: 

       

       

      these steps are the main ones. I did not use transpose. I loaded the tables and the result is same. 

       

       

      • dsj8wksnnckk's avatar
        dsj8wksnnckk
        Resolver I
        2 years ago

        Hey, can you re-upload the file? It was deleted and I seem to have lost it 😞